DBA Data[Home] [Help]

APPS.PAY_MX_YREND_ARCH dependencies on PAY_ACTION_INFORMATION

Line 1345: ( select 1 from pay_action_information

1341: from pay_assignment_actions
1342: where assignment_action_id = p_archive_action_id)
1343: and payroll_action_id = ppa.payroll_action_id )
1344: and not exists
1345: ( select 1 from pay_action_information
1346: where action_context_id in
1347: (select assignment_action_id
1348: from pay_assignment_actions
1349: where assignment_id in

Line 1430: FROM pay_action_information

1426: AND pps.period_of_service_id = paf.period_of_service_id;
1427:
1428: CURSOR c_check_pay_action(cp_payroll_action_id IN NUMBER) IS
1429: SELECT count(*)
1430: FROM pay_action_information
1431: WHERE action_context_id = cp_payroll_action_id
1432: AND action_context_type = 'PA';
1433:
1434: -- Get Generic Hierarchy Details for the current BG