APPS.PAY_IN_TERMINATION_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 447: pay_assignment_actions paa

443: ptp.end_date
444: FROM
445: per_time_periods ptp,
446: pay_payroll_actions ppa,
447: pay_assignment_actions paa
448: WHERE ptp.payroll_id = p_payroll_id
449: AND ptp.start_date between TRUNC(p_start_date,'MM') AND p_end_date
450: AND ptp.payroll_id = ppa.payroll_id
451: AND ptp.time_period_id = ppa.time_period_id

Line 467: pay_assignment_actions paa

463: ptp.end_date
464: FROM
465: per_time_periods ptp,
466: pay_payroll_actions ppa,
467: pay_assignment_actions paa
468: WHERE ptp.payroll_id = p_payroll_id
469: AND ptp.payroll_id = ppa.payroll_id
470: AND ptp.time_period_id = ppa.time_period_id
471: AND ppa.payroll_action_id = paa.payroll_action_id

Line 1308: pay_assignment_actions paa,

1304: --
1305: CURSOR csr_element_proc IS
1306: SELECT 1
1307: FROM pay_run_results prr,
1308: pay_assignment_actions paa,
1309: pay_element_types_f pet,
1310: pay_payroll_Actions ppa
1311: WHERE paa.assignment_id = p_assignment_id
1312: AND paa.assignment_action_id = prr.assignment_action_id

Line 2775: pay_assignment_actions paa,

2771: AND pet2.element_name = SUBSTR(pet.element_name,1,INSTR(pet.element_name,' Recover',-1))||'Advance'
2772: AND p_actual_termination_date BETWEEN pet.effective_start_date AND pet.effective_end_date
2773: AND EXISTS (SELECT '1'
2774: FROM pay_run_results prr,
2775: pay_assignment_actions paa,
2776: pay_payroll_Actions ppa
2777: WHERE paa.assignment_id = g_assignment_id
2778: AND paa.assignment_action_id = prr.assignment_action_id
2779: AND paa.payroll_action_id= ppa.payroll_action_id

Line 2790: FROM pay_assignment_actions paa

2786: );
2787:
2788: CURSOR csr_asact_id IS
2789: SELECT MAX(paa.assignment_action_id)
2790: FROM pay_assignment_actions paa
2791: ,pay_payroll_actions ppa
2792: WHERE paa.assignment_id = g_assignment_id
2793: AND paa.payroll_action_id = ppa.payroll_action_id
2794: AND paa.action_status = 'C'

Line 3255: FROM pay_assignment_actions paa

3251: l_def_bal_id pay_defined_balances.defined_balance_id%TYPE;
3252:
3253: CURSOR csr_asact_id IS
3254: SELECT max(paa.assignment_action_id)
3255: FROM pay_assignment_actions paa
3256: ,pay_payroll_actions ppa
3257: WHERE paa.assignment_id = g_assignment_id
3258: AND paa.payroll_action_id = ppa.payroll_action_id
3259: AND paa.action_status = 'C'

Line 3264: l_asact_id pay_assignment_actions.assignment_action_id%TYPE;

3260: AND paa.source_action_id IS NULL
3261: AND ppa.action_type in ('R','Q')
3262: AND ppa.action_status = 'C' ;
3263:
3264: l_asact_id pay_assignment_actions.assignment_action_id%TYPE;
3265: BEGIN
3266: g_debug := hr_utility.debug_enabled ;
3267: l_procedure := g_package || 'create_loan_entry' ;
3268: p_message_name := 'SUCCESS';

Line 4005: ,pay_assignment_actions paa

4001:
4002: CURSOR c_max_asact IS
4003: SELECT MAX(paa.assignment_action_id)
4004: FROM pay_payroll_Actions ppa
4005: ,pay_assignment_actions paa
4006: WHERE paa.assignment_id =p_assignment_id
4007: AND paa.payroll_action_id = ppa.payroll_Action_id
4008: AND ppa.action_type in('R','Q')
4009: AND TRUNC(ppa.date_earned,'MM') = TRUNC(p_end_date,'MM')