APPS.PQP_GB_TP_CONTRIBUTION_REPORT dependencies on PAY_ASSIGNMENT_ACTIONS

Line 24: FROM PAY_ASSIGNMENT_ACTIONS

20: INTO A
21: FROM PAY_PAYROLL_ACTIONS
22: WHERE PAYROLL_ACTION_ID =
23: (SELECT MAX(PAYROLL_ACTION_ID)
24: FROM PAY_ASSIGNMENT_ACTIONS
25: WHERE ASSIGNMENT_ID = p_assignment_id
26: )
27: AND ACTION_TYPE IN ('L','G','O');
28: hr_utility.set_location('**** This is retro ' , 30);

Line 64: pay_assignment_actions paa ,

60: SELECT MAX(NVL(DECODE(PIVF.NAME,'Pension Tier A',prrv.result_value),0)) Pension_Tier_A,
61: MAX(NVL(DECODE(PIVF.NAME,'Pension Tier B',prrv.result_value),0)) Pension_Tier_B,
62: MAX(NVL(DECODE(PIVF.NAME,'Pension Tier C',prrv.result_value),0)) Pension_Tier_C
63: FROM pay_payroll_actions ppa ,
64: pay_assignment_actions paa ,
65: pay_run_results prr ,
66: pay_run_result_values prrv ,
67: pay_input_values_f pivf ,
68: PER_TIME_PERIODS PTP

Line 94: select source_action_id into l_source_action_id from pay_assignment_actions where assignment_action_id =p_assignment_action_id;

90:
91:
92: BEGIN
93: hr_utility.trace('Entering : TPS_Pension_tier');
94: select source_action_id into l_source_action_id from pay_assignment_actions where assignment_action_id =p_assignment_action_id;
95: hr_utility.trace('source_action_id :'|| l_source_action_id);
96:
97: OPEN c_element_type_id;
98: FETCH c_element_type_id INTO l_element_id;

Line 179: pay_assignment_actions paa ,

175: SUM(NVL(DECODE(PIVF.NAME,'Annual FTE Sal A',prrv.result_value),0)) Annual_FTE_Sal_A,
176: SUM(NVL(DECODE(PIVF.NAME,'Annual FTE Sal B',prrv.result_value),0)) Annual_FTE_Sal_B,
177: SUM(NVL(DECODE(PIVF.NAME,'Annual FTE Sal C',prrv.result_value),0)) Annual_FTE_Sal_C
178: FROM pay_payroll_actions ppa ,
179: pay_assignment_actions paa ,
180: pay_run_results prr ,
181: pay_run_result_values prrv ,
182: pay_input_values_f pivf ,
183: PER_TIME_PERIODS PTP

Line 213: select source_action_id into l_source_action_id from pay_assignment_actions where assignment_action_id =p_assignment_action_id;

209:
210:
211: BEGIN
212: hr_utility.trace('Entering : TPS_Pension_Input_values');
213: select source_action_id into l_source_action_id from pay_assignment_actions where assignment_action_id =p_assignment_action_id;
214: hr_utility.trace('source_action_id :'|| l_source_action_id);
215:
216: OPEN c_element_type_id;
217: FETCH c_element_type_id INTO l_element_id;

Line 392: ,pay_assignment_actions paa

388: ,p_time_period_id pay_payroll_actions.time_period_id%TYPE
389: ,p_element_type_id pay_run_results.element_type_id%TYPE) IS
390: SELECT COUNT (DISTINCT paa.assignment_id) asg_count
391: FROM pay_payroll_actions ppa
392: ,pay_assignment_actions paa
393: ,pay_run_results prr
394: WHERE ppa.business_group_id = p_business_group_id
395: AND ppa.payroll_id = p_payroll_id
396: AND ppa.action_status = 'C'

Line 412: ,pay_assignment_actions paa

408: ,p_time_period_id pay_payroll_actions.time_period_id%TYPE
409: ,p_element_type_id pay_run_results.element_type_id%TYPE) IS
410: SELECT COUNT (DISTINCT paa.assignment_id) asg_count
411: FROM pay_payroll_actions ppa
412: ,pay_assignment_actions paa
413: ,pay_run_results prr
414: WHERE ppa.business_group_id = p_business_group_id
415: AND ppa.payroll_id = p_payroll_id
416: AND ppa.action_status = 'C'

Line 453: ,pay_assignment_actions paa

449: ,p_input_values.er
450: ,prrv.result_value
451: ,0)) er
452: FROM pay_payroll_actions ppa
453: ,pay_assignment_actions paa
454: ,pay_run_results prr
455: ,pay_run_result_values prrv
456: WHERE ppa.business_group_id = p_business_group_id
457: AND ppa.payroll_id = p_payroll_id

Line 506: ,pay_assignment_actions paa

502: (
503: SELECT paa.ASSIGNMENT_ACTION_ID
504: FROM pay_element_entries_f peef
505: ,per_time_periods ptp
506: ,pay_assignment_actions paa
507: WHERE element_type_id = p_element_type_id
508: AND CREATOR_TYPE = 'RR'
509: AND ptp.TIME_PERIOD_ID = p_time_period_id
510: AND ptp.START_DATE = peef.effective_start_date

Line 583: ,pay_assignment_actions paa

579: SELECT COUNT(DISTINCT(paa.ASSIGNMENT_ID))
580: INTO r_retro_employee_count
581: FROM pay_element_entries_f peef
582: ,per_time_periods ptp
583: ,pay_assignment_actions paa
584: WHERE element_type_id = r_element_type_details.element_type_id
585: AND CREATOR_TYPE = 'RR'
586: AND ptp.TIME_PERIOD_ID = p_period
587: AND ptp.START_DATE = peef.effective_start_date