DBA Data[Home] [Help]

APPS.PAY_MX_YREND_ARCH dependencies on PAY_ACTION_INFORMATION

Line 1585: ( select 1 from pay_action_information

1581: where assignment_action_id = p_archive_action_id
1582: and assignment_id = paf.assignment_id)
1583: and payroll_action_id = ppa.payroll_action_id )
1584: and not exists
1585: ( select 1 from pay_action_information
1586: where action_context_id in
1587: (select assignment_action_id
1588: from pay_assignment_actions
1589: where assignment_id in

Line 1676: FROM pay_action_information

1672:
1673:
1674: CURSOR c_check_pay_action(cp_payroll_action_id IN NUMBER) IS
1675: SELECT count(*)
1676: FROM pay_action_information
1677: WHERE action_context_id = cp_payroll_action_id
1678: AND action_context_type = 'PA';
1679:
1680: -- Get Generic Hierarchy Details for the current BG