DBA Data[Home] [Help]

APPS.PAY_SE_INCOME_STATEMENT dependencies on PAY_RUN_RESULTS

Line 2340: FROM pay_run_results prr

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

Line 2357: FROM pay_run_results sub_rr

2353: AND prr.source_type = 'E'
2354: AND prr.status <> 'U'
2355: AND NOT EXISTS (
2356: SELECT 1
2357: FROM pay_run_results sub_rr
2358: WHERE sub_rr.source_id = prr.run_result_id
2359: AND sub_rr.source_type IN ('R', 'V'));
2360:
2361: CURSOR csr_get_car_elem (csr_v_assignment_id NUMBER)