APPS.PAY_SE_INCOME_STATEMENT dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 1005: csr_v_input_value_id pay_element_entry_values_f.input_value_id%TYPE

1001:
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: )

Line 1013: ,pay_element_entry_values_f peev

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
1017: AND peev.effective_end_date = pee.effective_end_date

Line 2242: csr_v_input_value_id pay_element_entry_values_f.input_value_id%TYPE

2238: lr_get_element_type_id csr_get_element_type_id%ROWTYPE;
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

Line 2250: , pay_element_entry_values_f peev

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
2253: AND peev.input_value_id = csr_v_input_value_id
2254: AND peev.EFFECTIVE_START_DATE = pee.EFFECTIVE_START_DATE

Line 2280: csr_v_input_value_id pay_element_entry_values_f.input_value_id%TYPE

2276: )
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: )

Line 2288: ,pay_element_entry_values_f peev

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
2292: AND peev.effective_end_date = pee.effective_end_date

Line 2406: ,pay_element_entry_values_f peev

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
2409: AND piv.NAME = 'RSV Code'
2410: AND peev.element_entry_id = pee.element_entry_id