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 2772: pay_assignment_actions paa,

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

Line 2787: FROM pay_assignment_actions paa

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

Line 3252: FROM pay_assignment_actions paa

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

Line 3261: l_asact_id pay_assignment_actions.assignment_action_id%TYPE;

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

Line 4002: ,pay_assignment_actions paa

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