APPS.PAY_SE_INCOME_STATEMENT dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 999: csr_v_input_value_id pay_element_entry_values_f.input_value_id%TYPE

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

Line 1007: ,pay_element_entry_values_f peev

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

Line 2227: csr_v_input_value_id pay_element_entry_values_f.input_value_id%TYPE

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

Line 2235: , pay_element_entry_values_f peev

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

Line 2265: csr_v_input_value_id pay_element_entry_values_f.input_value_id%TYPE

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

Line 2273: ,pay_element_entry_values_f peev

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

Line 2391: ,pay_element_entry_values_f peev

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