DBA Data[Home] [Help]

APPS.PAY_NL_ABP_ARCHIVE dependencies on PAY_RUN_RESULTS

Line 476: FROM pay_run_results

472: ,p_element_type_id IN NUMBER ) RETURN BOOLEAN IS
473:
474: CURSOR csr_ass_act IS
475: SELECT 1
476: FROM pay_run_results
477: WHERE assignment_action_id = p_ass_act_id
478: AND element_type_id = p_element_type_id;
479:
480: l_dummy NUMBER;

Line 643: FROM pay_run_results prr

639: ppa.action_type = 'B'
640: AND EXISTS
641: (
642: SELECT 1
643: FROM pay_run_results prr
644: , pay_run_result_values prv
645: , pay_balance_feeds_f pbf
646: , pay_defined_balances db
647: WHERE prr.assignment_action_id = paa.assignment_action_id

Line 1494: FROM pay_run_results prr

1490: -- ============================================================================
1491: CURSOR csr_get_retro_entry(c_element_type_id in number
1492: ,c_assignment_action_id in number) IS
1493: SELECT element_entry_id
1494: FROM pay_run_results prr
1495: WHERE prr.assignment_action_id = c_assignment_action_id
1496: AND prr.element_type_id = c_element_type_id
1497: ORDER BY element_entry_id;
1498: