eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_SE_INCOME_STATEMENT dependencies on PAY_ELEMENT_ENTRIES_F

Line 1000: ,csr_v_link_id pay_element_entries_f.element_link_id%TYPE

996: lr_get_element_ids csr_get_element_ids%ROWTYPE;
997:
998: CURSOR csr_chk_a_taxcard (
999: csr_v_input_value_id pay_element_entry_values_f.input_value_id%TYPE
1000: ,csr_v_link_id pay_element_entries_f.element_link_id%TYPE
1001: ,csr_v_type_id pay_element_entries_f.element_type_id%TYPE
1002: ,csr_v_prim_assignment_id NUMBER
1003: )
1004: IS

Line 1001: ,csr_v_type_id pay_element_entries_f.element_type_id%TYPE

997:
998: CURSOR csr_chk_a_taxcard (
999: csr_v_input_value_id pay_element_entry_values_f.input_value_id%TYPE
1000: ,csr_v_link_id pay_element_entries_f.element_link_id%TYPE
1001: ,csr_v_type_id pay_element_entries_f.element_type_id%TYPE
1002: ,csr_v_prim_assignment_id NUMBER
1003: )
1004: IS
1005: SELECT COUNT ('Y') valid

Line 1006: FROM pay_element_entries_f pee

1002: ,csr_v_prim_assignment_id NUMBER
1003: )
1004: IS
1005: SELECT COUNT ('Y') valid
1006: FROM pay_element_entries_f pee
1007: ,pay_element_entry_values_f peev
1008: WHERE peev.screen_entry_value = 'A'
1009: AND peev.element_entry_id = pee.element_entry_id
1010: AND peev.effective_start_date = pee.effective_start_date

Line 2228: ,csr_v_link_id pay_element_entries_f.ELEMENT_LINK_ID%TYPE

2224:
2225: /*
2226: CURSOR csr_chk_A_taxcard (
2227: csr_v_input_value_id pay_element_entry_values_f.input_value_id%TYPE
2228: ,csr_v_link_id pay_element_entries_f.ELEMENT_LINK_ID%TYPE
2229: ,csr_v_type_id pay_element_entries_f.ELEMENT_TYPE_ID%TYPE
2230: ,csr_v_person_id NUMBER
2231: ) is
2232: SELECT count('Y') VALID

Line 2229: ,csr_v_type_id pay_element_entries_f.ELEMENT_TYPE_ID%TYPE

2225: /*
2226: CURSOR csr_chk_A_taxcard (
2227: csr_v_input_value_id pay_element_entry_values_f.input_value_id%TYPE
2228: ,csr_v_link_id pay_element_entries_f.ELEMENT_LINK_ID%TYPE
2229: ,csr_v_type_id pay_element_entries_f.ELEMENT_TYPE_ID%TYPE
2230: ,csr_v_person_id NUMBER
2231: ) is
2232: SELECT count('Y') VALID
2233: from pay_element_entries_f pee

Line 2233: from pay_element_entries_f pee

2229: ,csr_v_type_id pay_element_entries_f.ELEMENT_TYPE_ID%TYPE
2230: ,csr_v_person_id NUMBER
2231: ) is
2232: SELECT count('Y') VALID
2233: from pay_element_entries_f pee
2234: , per_all_assignments_f paa
2235: , pay_element_entry_values_f peev
2236: where peev.screen_entry_value ='A'
2237: AND peev.element_entry_id = pee.element_entry_id

Line 2266: ,csr_v_link_id pay_element_entries_f.element_link_id%TYPE

2262: );
2263: */
2264: CURSOR csr_chk_a_taxcard (
2265: csr_v_input_value_id pay_element_entry_values_f.input_value_id%TYPE
2266: ,csr_v_link_id pay_element_entries_f.element_link_id%TYPE
2267: ,csr_v_type_id pay_element_entries_f.element_type_id%TYPE
2268: ,csr_v_prim_assignment_id NUMBER
2269: )
2270: IS

Line 2267: ,csr_v_type_id pay_element_entries_f.element_type_id%TYPE

2263: */
2264: CURSOR csr_chk_a_taxcard (
2265: csr_v_input_value_id pay_element_entry_values_f.input_value_id%TYPE
2266: ,csr_v_link_id pay_element_entries_f.element_link_id%TYPE
2267: ,csr_v_type_id pay_element_entries_f.element_type_id%TYPE
2268: ,csr_v_prim_assignment_id NUMBER
2269: )
2270: IS
2271: SELECT COUNT ('Y') valid

Line 2272: FROM pay_element_entries_f pee

2268: ,csr_v_prim_assignment_id NUMBER
2269: )
2270: IS
2271: SELECT COUNT ('Y') valid
2272: FROM pay_element_entries_f pee
2273: ,pay_element_entry_values_f peev
2274: WHERE peev.screen_entry_value = 'A'
2275: AND peev.element_entry_id = pee.element_entry_id
2276: AND peev.effective_start_date = pee.effective_start_date

Line 2321: ,pay_element_entries_f pee

2317: ,pel.element_link_id
2318: ,pee.element_entry_id
2319: FROM pay_element_types_f pet
2320: ,pay_element_links_f pel
2321: ,pay_element_entries_f pee
2322: WHERE pel.element_type_id = pet.element_type_id
2323: AND (pet.legislation_code = 'SE' OR pet.legislation_code IS NULL
2324: )
2325: AND pel.business_group_id = g_business_group_id

Line 2341: ,pay_element_entries_f pee

2337: CURSOR csr_get_elem_processed (csr_v_element_entry_id NUMBER)
2338: IS
2339: SELECT 'Y' "PROCESSED"
2340: FROM pay_run_results prr
2341: ,pay_element_entries_f pee
2342: WHERE pee.element_entry_id =
2343: csr_v_element_entry_id
2344: --p_p_element_entry_id
2345: /*and p_effective_date* between pee.effective_start_date

Line 2367: FROM pay_element_entries_f pee

2363: SELECT pee.element_entry_id
2364: ,pet.element_name
2365: ,pee.effective_start_date
2366: ,pee.effective_end_date
2367: FROM pay_element_entries_f pee
2368: ,pay_element_types_f pet
2369: WHERE pet.element_name = 'Car Benefit'
2370: AND pet.legislation_code = 'SE'
2371: AND pee.assignment_id = csr_v_assignment_id

Line 2389: FROM pay_element_entries_f pee

2385: SELECT pee.element_entry_id
2386: ,pee.effective_start_date
2387: ,pee.effective_end_date
2388: ,peev.screen_entry_value
2389: FROM pay_element_entries_f pee
2390: ,pay_input_values_f piv
2391: ,pay_element_entry_values_f peev
2392: WHERE pee.element_entry_id = csr_v_ee_id
2393: AND piv.element_type_id = piv.element_type_id