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_RUN_RESULTS

Line 65: pay_run_results prr ,

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
69: WHERE ppa.business_group_id = p_business_group_id --Context

Line 180: pay_run_results prr ,

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
184: WHERE ppa.business_group_id = p_business_group_id --Context

Line 389: ,p_element_type_id pay_run_results.element_type_id%TYPE) IS

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
393: ,pay_run_results prr

Line 393: ,pay_run_results prr

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'
397: AND ppa.time_period_id = p_time_period_id

Line 409: ,p_element_type_id pay_run_results.element_type_id%TYPE) IS

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
413: ,pay_run_results prr

Line 413: ,pay_run_results prr

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'
417: AND ppa.time_period_id = p_time_period_id

Line 428: ,p_element_type_id pay_run_results.element_type_id%TYPE

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
432: ,sum (ee) ee

Line 454: ,pay_run_results prr

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
458: AND ppa.action_status = 'C'

Line 475: ,p_element_type_id pay_run_results.element_type_id%TYPE

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
479: ,sum (ee) ee

Line 499: FROM pay_run_results prr

495: ,sum (decode (prrv.input_value_id
496: ,p_input_values.er
497: ,prrv.result_value
498: ,0)) er
499: FROM pay_run_results prr
500: ,pay_run_result_values prrv
501: WHERE prr.assignment_action_id IN
502: (
503: SELECT paa.ASSIGNMENT_ACTION_ID