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.PAY_GB_RTI_EYU dependencies on PAY_GB_EOY_ARCHIVE

Line 3568: select pay_gb_eoy_archive.get_parameter(legislative_parameters, 'TEST'),

3564: IS
3565:
3566:
3567: cursor csr_parameter_info is
3568: select pay_gb_eoy_archive.get_parameter(legislative_parameters, 'TEST'),
3569: /*ppa.effective_date*/
3570: sysdate
3571: from pay_payroll_actions ppa
3572: ,pay_assignment_actions paa

Line 3842: SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'TAX_REF'),1,20) tax_ref,

3838:
3839: CURSOR csr_parameter_info
3840: IS
3841: SELECT
3842: SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'TAX_REF'),1,20) tax_ref,
3843: effective_date,
3844: business_group_id
3845: FROM pay_payroll_actions pact
3846: WHERE payroll_action_id = pactid;

Line 3893: and UPPER(l_tax_ref) = UPPER(SUBSTR(pay_gb_eoy_archive.get_parameter(ppa.legislative_parameters,'TAX_REF'),1,20))

3889: and ppa.action_type ='X'
3890: and ppa.payroll_action_id = paa.payroll_action_id
3891: and ppa.report_type in( 'RTI_FPS_REP' , 'RTI_EYU_REP_13')
3892: and ppa.effective_date >= g_start_year
3893: and UPPER(l_tax_ref) = UPPER(SUBSTR(pay_gb_eoy_archive.get_parameter(ppa.legislative_parameters,'TAX_REF'),1,20))
3894: order by ppa.effective_date desc;
3895:
3896: CURSOR csr_latest_asg_action1(asg_id number,p_pact_id number) is
3897: select paa.ASSIGNMENT_ACTION_ID , ppa.EFFECTIVE_DATE from pay_payroll_actions ppa,pay_assignment_actions paa

Line 4602: SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'TAX_REF'),1,20) tax_ref

4598:
4599: CURSOR csr_parameter_info(p_payroll_action_id NUMBER)
4600: IS
4601: SELECT
4602: SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'TAX_REF'),1,20) tax_ref
4603: FROM pay_payroll_actions
4604: WHERE payroll_action_id = p_payroll_action_id;
4605:
4606: CURSOR csr_payroll_details(pactid NUMBER)

Line 5432: and UPPER(g_tax_ref) = UPPER(SUBSTR(pay_gb_eoy_archive.get_parameter(ppa.legislative_parameters,'TAX_REF'),1,20))

5428: where paa.assignment_id = asg_id
5429: and paa.action_status ='C'
5430: and ppa.payroll_action_id = paa.payroll_action_id
5431: and ppa.report_type in ( 'RTI_FPS_REP' , 'RTI_EYU_REP_13')
5432: and UPPER(g_tax_ref) = UPPER(SUBSTR(pay_gb_eoy_archive.get_parameter(ppa.legislative_parameters,'TAX_REF'),1,20))
5433: order by ppa.effective_date desc;
5434:
5435: --cursor to get person latest fps run
5436: cursor csr_latest_fps_payeagg(per_id number) is

Line 5824: and ppf.payroll_id = SUBSTR(pay_gb_eoy_archive.get_parameter(ppa.legislative_parameters,'PAYROLL'),1,20);

5820: IS
5821: SELECT ppf.PAYROLL_NAME
5822: from pay_payrolls_f ppf,pay_payroll_actions ppa
5823: WHERE ppa.payroll_action_id = pactid
5824: and ppf.payroll_id = SUBSTR(pay_gb_eoy_archive.get_parameter(ppa.legislative_parameters,'PAYROLL'),1,20);
5825:
5826: -- Cursor to fetch Errored Records
5827: CURSOR get_asg_action_id_error
5828: IS