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 1006: ,csr_v_link_id pay_element_entries_f.element_link_id%TYPE

1002: lr_get_element_ids csr_get_element_ids%ROWTYPE;
1003:
1004: CURSOR csr_chk_a_taxcard (
1005: csr_v_input_value_id pay_element_entry_values_f.input_value_id%TYPE
1006: ,csr_v_link_id pay_element_entries_f.element_link_id%TYPE
1007: ,csr_v_type_id pay_element_entries_f.element_type_id%TYPE
1008: ,csr_v_prim_assignment_id NUMBER
1009: )
1010: IS

Line 1007: ,csr_v_type_id pay_element_entries_f.element_type_id%TYPE

1003:
1004: CURSOR csr_chk_a_taxcard (
1005: csr_v_input_value_id pay_element_entry_values_f.input_value_id%TYPE
1006: ,csr_v_link_id pay_element_entries_f.element_link_id%TYPE
1007: ,csr_v_type_id pay_element_entries_f.element_type_id%TYPE
1008: ,csr_v_prim_assignment_id NUMBER
1009: )
1010: IS
1011: SELECT COUNT ('Y') valid

Line 1012: FROM pay_element_entries_f pee

1008: ,csr_v_prim_assignment_id NUMBER
1009: )
1010: IS
1011: SELECT COUNT ('Y') valid
1012: FROM pay_element_entries_f pee
1013: ,pay_element_entry_values_f peev
1014: WHERE peev.screen_entry_value = 'A'
1015: AND peev.element_entry_id = pee.element_entry_id
1016: AND peev.effective_start_date = pee.effective_start_date

Line 2243: ,csr_v_link_id pay_element_entries_f.ELEMENT_LINK_ID%TYPE

2239:
2240: /*
2241: CURSOR csr_chk_A_taxcard (
2242: csr_v_input_value_id pay_element_entry_values_f.input_value_id%TYPE
2243: ,csr_v_link_id pay_element_entries_f.ELEMENT_LINK_ID%TYPE
2244: ,csr_v_type_id pay_element_entries_f.ELEMENT_TYPE_ID%TYPE
2245: ,csr_v_person_id NUMBER
2246: ) is
2247: SELECT count('Y') VALID

Line 2244: ,csr_v_type_id pay_element_entries_f.ELEMENT_TYPE_ID%TYPE

2240: /*
2241: CURSOR csr_chk_A_taxcard (
2242: csr_v_input_value_id pay_element_entry_values_f.input_value_id%TYPE
2243: ,csr_v_link_id pay_element_entries_f.ELEMENT_LINK_ID%TYPE
2244: ,csr_v_type_id pay_element_entries_f.ELEMENT_TYPE_ID%TYPE
2245: ,csr_v_person_id NUMBER
2246: ) is
2247: SELECT count('Y') VALID
2248: from pay_element_entries_f pee

Line 2248: from pay_element_entries_f pee

2244: ,csr_v_type_id pay_element_entries_f.ELEMENT_TYPE_ID%TYPE
2245: ,csr_v_person_id NUMBER
2246: ) is
2247: SELECT count('Y') VALID
2248: from pay_element_entries_f pee
2249: , per_all_assignments_f paa
2250: , pay_element_entry_values_f peev
2251: where peev.screen_entry_value ='A'
2252: AND peev.element_entry_id = pee.element_entry_id

Line 2281: ,csr_v_link_id pay_element_entries_f.element_link_id%TYPE

2277: );
2278: */
2279: CURSOR csr_chk_a_taxcard (
2280: csr_v_input_value_id pay_element_entry_values_f.input_value_id%TYPE
2281: ,csr_v_link_id pay_element_entries_f.element_link_id%TYPE
2282: ,csr_v_type_id pay_element_entries_f.element_type_id%TYPE
2283: ,csr_v_prim_assignment_id NUMBER
2284: )
2285: IS

Line 2282: ,csr_v_type_id pay_element_entries_f.element_type_id%TYPE

2278: */
2279: CURSOR csr_chk_a_taxcard (
2280: csr_v_input_value_id pay_element_entry_values_f.input_value_id%TYPE
2281: ,csr_v_link_id pay_element_entries_f.element_link_id%TYPE
2282: ,csr_v_type_id pay_element_entries_f.element_type_id%TYPE
2283: ,csr_v_prim_assignment_id NUMBER
2284: )
2285: IS
2286: SELECT COUNT ('Y') valid

Line 2287: FROM pay_element_entries_f pee

2283: ,csr_v_prim_assignment_id NUMBER
2284: )
2285: IS
2286: SELECT COUNT ('Y') valid
2287: FROM pay_element_entries_f pee
2288: ,pay_element_entry_values_f peev
2289: WHERE peev.screen_entry_value = 'A'
2290: AND peev.element_entry_id = pee.element_entry_id
2291: AND peev.effective_start_date = pee.effective_start_date

Line 2336: ,pay_element_entries_f pee

2332: ,pel.element_link_id
2333: ,pee.element_entry_id
2334: FROM pay_element_types_f pet
2335: ,pay_element_links_f pel
2336: ,pay_element_entries_f pee
2337: WHERE pel.element_type_id = pet.element_type_id
2338: AND (pet.legislation_code = 'SE' OR pet.legislation_code IS NULL
2339: )
2340: AND pel.business_group_id = g_business_group_id

Line 2356: ,pay_element_entries_f pee

2352: CURSOR csr_get_elem_processed (csr_v_element_entry_id NUMBER)
2353: IS
2354: SELECT 'Y' "PROCESSED"
2355: FROM pay_run_results prr
2356: ,pay_element_entries_f pee
2357: WHERE pee.element_entry_id =
2358: csr_v_element_entry_id
2359: --p_p_element_entry_id
2360: /*and p_effective_date* between pee.effective_start_date

Line 2382: FROM pay_element_entries_f pee

2378: SELECT pee.element_entry_id
2379: ,pet.element_name
2380: ,pee.effective_start_date
2381: ,pee.effective_end_date
2382: FROM pay_element_entries_f pee
2383: ,pay_element_types_f pet
2384: WHERE pet.element_name = 'Car Benefit'
2385: AND pet.legislation_code = 'SE'
2386: AND pee.assignment_id = csr_v_assignment_id

Line 2404: FROM pay_element_entries_f pee

2400: SELECT pee.element_entry_id
2401: ,pee.effective_start_date
2402: ,pee.effective_end_date
2403: ,peev.screen_entry_value
2404: FROM pay_element_entries_f pee
2405: ,pay_input_values_f piv
2406: ,pay_element_entry_values_f peev
2407: WHERE pee.element_entry_id = csr_v_ee_id
2408: AND piv.element_type_id = piv.element_type_id