eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQP_GB_TP_CONTRIBUTION_REPORT dependencies on PAY_PAYROLL_ACTIONS

Line 21: FROM PAY_PAYROLL_ACTIONS

17: hr_utility.set_location(' Assignment ID '||p_assignment_id , 20);
18: BEGIN
19: SELECT 0
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

Line 63: FROM pay_payroll_actions ppa ,

59: IS
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 ,

Line 178: FROM pay_payroll_actions ppa ,

174: SUM(NVL(DECODE(PIVF.NAME,'ER Contribution C',prrv.result_value),0)) ER_Contribution_C,
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 ,

Line 386: CURSOR csr_employee_count(p_business_group_id pay_payroll_actions.business_group_id%TYPE

382: ,length (name)
383: ,1);
384: ---------------------
385: -- Modified Cursor as part of fix for bug#14392137
386: CURSOR csr_employee_count(p_business_group_id pay_payroll_actions.business_group_id%TYPE
387: ,p_payroll_id pay_payroll_actions.payroll_id%TYPE
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

Line 387: ,p_payroll_id pay_payroll_actions.payroll_id%TYPE

383: ,1);
384: ---------------------
385: -- Modified Cursor as part of fix for bug#14392137
386: CURSOR csr_employee_count(p_business_group_id pay_payroll_actions.business_group_id%TYPE
387: ,p_payroll_id pay_payroll_actions.payroll_id%TYPE
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

Line 388: ,p_time_period_id pay_payroll_actions.time_period_id%TYPE

384: ---------------------
385: -- Modified Cursor as part of fix for bug#14392137
386: CURSOR csr_employee_count(p_business_group_id pay_payroll_actions.business_group_id%TYPE
387: ,p_payroll_id pay_payroll_actions.payroll_id%TYPE
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

Line 391: FROM pay_payroll_actions ppa

387: ,p_payroll_id pay_payroll_actions.payroll_id%TYPE
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

Line 406: CURSOR csr_employee_count_rev(p_business_group_id pay_payroll_actions.business_group_id%TYPE

402: AND prr.assignment_action_id = paa.assignment_action_id
403: AND prr.element_type_id = p_element_type_id;
404: ---------------------
405: -- Created Cursor as part of fix for bug#14392137 for reversal count
406: CURSOR csr_employee_count_rev(p_business_group_id pay_payroll_actions.business_group_id%TYPE
407: ,p_payroll_id pay_payroll_actions.payroll_id%TYPE
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

Line 407: ,p_payroll_id pay_payroll_actions.payroll_id%TYPE

403: AND prr.element_type_id = p_element_type_id;
404: ---------------------
405: -- Created Cursor as part of fix for bug#14392137 for reversal count
406: CURSOR csr_employee_count_rev(p_business_group_id pay_payroll_actions.business_group_id%TYPE
407: ,p_payroll_id pay_payroll_actions.payroll_id%TYPE
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

Line 408: ,p_time_period_id pay_payroll_actions.time_period_id%TYPE

404: ---------------------
405: -- Created Cursor as part of fix for bug#14392137 for reversal count
406: CURSOR csr_employee_count_rev(p_business_group_id pay_payroll_actions.business_group_id%TYPE
407: ,p_payroll_id pay_payroll_actions.payroll_id%TYPE
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

Line 411: FROM pay_payroll_actions ppa

407: ,p_payroll_id pay_payroll_actions.payroll_id%TYPE
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

Line 425: CURSOR csr_run_results(p_business_group_id pay_payroll_actions.business_group_id%TYPE

421: AND prr.assignment_action_id = paa.assignment_action_id
422: AND prr.element_type_id = p_element_type_id;
423: ---------------------
424: -- Modified Cursor as part of fix for bug#14392137
425: CURSOR csr_run_results(p_business_group_id pay_payroll_actions.business_group_id%TYPE
426: ,p_payroll_id pay_payroll_actions.payroll_id%TYPE
427: ,p_time_period_id pay_payroll_actions.time_period_id%TYPE
428: ,p_element_type_id pay_run_results.element_type_id%TYPE
429: ,p_input_values csr_input_value_details%ROWTYPE) IS

Line 426: ,p_payroll_id pay_payroll_actions.payroll_id%TYPE

422: AND prr.element_type_id = p_element_type_id;
423: ---------------------
424: -- Modified Cursor as part of fix for bug#14392137
425: CURSOR csr_run_results(p_business_group_id pay_payroll_actions.business_group_id%TYPE
426: ,p_payroll_id pay_payroll_actions.payroll_id%TYPE
427: ,p_time_period_id pay_payroll_actions.time_period_id%TYPE
428: ,p_element_type_id pay_run_results.element_type_id%TYPE
429: ,p_input_values csr_input_value_details%ROWTYPE) IS
430: SELECT abs(to_number(tier)) tier

Line 427: ,p_time_period_id pay_payroll_actions.time_period_id%TYPE

423: ---------------------
424: -- Modified Cursor as part of fix for bug#14392137
425: CURSOR csr_run_results(p_business_group_id pay_payroll_actions.business_group_id%TYPE
426: ,p_payroll_id pay_payroll_actions.payroll_id%TYPE
427: ,p_time_period_id pay_payroll_actions.time_period_id%TYPE
428: ,p_element_type_id pay_run_results.element_type_id%TYPE
429: ,p_input_values csr_input_value_details%ROWTYPE) IS
430: SELECT abs(to_number(tier)) tier
431: ,sum (pay) pay

Line 452: FROM pay_payroll_actions ppa

448: ,sum (decode (prrv.input_value_id
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

Line 472: CURSOR csr_run_results_retro(p_business_group_id pay_payroll_actions.business_group_id%TYPE

468: )
469: GROUP BY to_number(tier);
470: ---------------------
471: -- Created Cursor as part of fix for bug#14392137
472: CURSOR csr_run_results_retro(p_business_group_id pay_payroll_actions.business_group_id%TYPE
473: ,p_payroll_id pay_payroll_actions.payroll_id%TYPE
474: ,p_time_period_id pay_payroll_actions.time_period_id%TYPE
475: ,p_element_type_id pay_run_results.element_type_id%TYPE
476: ,p_input_values csr_input_value_details%ROWTYPE) IS

Line 473: ,p_payroll_id pay_payroll_actions.payroll_id%TYPE

469: GROUP BY to_number(tier);
470: ---------------------
471: -- Created Cursor as part of fix for bug#14392137
472: CURSOR csr_run_results_retro(p_business_group_id pay_payroll_actions.business_group_id%TYPE
473: ,p_payroll_id pay_payroll_actions.payroll_id%TYPE
474: ,p_time_period_id pay_payroll_actions.time_period_id%TYPE
475: ,p_element_type_id pay_run_results.element_type_id%TYPE
476: ,p_input_values csr_input_value_details%ROWTYPE) IS
477: SELECT abs(to_number(tier)) tier

Line 474: ,p_time_period_id pay_payroll_actions.time_period_id%TYPE

470: ---------------------
471: -- Created Cursor as part of fix for bug#14392137
472: CURSOR csr_run_results_retro(p_business_group_id pay_payroll_actions.business_group_id%TYPE
473: ,p_payroll_id pay_payroll_actions.payroll_id%TYPE
474: ,p_time_period_id pay_payroll_actions.time_period_id%TYPE
475: ,p_element_type_id pay_run_results.element_type_id%TYPE
476: ,p_input_values csr_input_value_details%ROWTYPE) IS
477: SELECT abs(to_number(tier)) tier
478: ,sum (pay) pay