DBA Data[Home] [Help]

APPS.PQP_NL_ABP_TEMPLATE dependencies on PAY_RUN_RESULTS

Line 2044: FROM pay_run_results prr

2040: CURSOR c_chk_rr_exist (c_element_type_id IN NUMBER) IS
2041: SELECT 1
2042: FROM dual
2043: WHERE EXISTS ( SELECT 1
2044: FROM pay_run_results prr
2045: WHERE prr.element_type_id = c_element_type_id) ;
2046:
2047: --
2048: -- Cursor to check if the element has been processed in

Line 2061: FROM pay_run_results prr

2057: AND ppa.action_status = 'C'
2058: AND paa.action_status = 'C'
2059: AND ppa.effective_date >= trunc(p_effective_date)
2060: AND EXISTS ( SELECT 1
2061: FROM pay_run_results prr
2062: WHERE prr.assignment_action_id = paa.assignment_action_id
2063: AND prr.element_type_id = c_in_ele_typ_id) ;
2064: --
2065: -- Cursor to get the formula rules of an element