DBA Data[Home] [Help]

APPS.PAY_SE_INCOME_STATEMENT dependencies on PAY_RUN_RESULTS

Line 2355: FROM pay_run_results prr

2351:
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

Line 2372: FROM pay_run_results sub_rr

2368: AND prr.source_type = 'E'
2369: AND prr.status <> 'U'
2370: AND NOT EXISTS (
2371: SELECT 1
2372: FROM pay_run_results sub_rr
2373: WHERE sub_rr.source_id = prr.run_result_id
2374: AND sub_rr.source_type IN ('R', 'V'));
2375:
2376: CURSOR csr_get_car_elem (csr_v_assignment_id NUMBER)