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

Line 502: pay_gb_eoy_archive.get_agg_active_start(p_person_rec.assignment_id,l_tax_ref,l_effective_date) start_date,

498: AND l_effective_date between e.effective_start_date and e.effective_end_date;
499:
500: cursor get_agg_start_end_dates is
501: select
502: pay_gb_eoy_archive.get_agg_active_start(p_person_rec.assignment_id,l_tax_ref,l_effective_date) start_date,
503: pay_gb_eoy_archive.get_agg_active_end(p_person_rec.assignment_id,l_tax_ref,l_effective_date) end_date
504: from dual;
505:
506: cursor csr_get_irregular_details is

Line 503: pay_gb_eoy_archive.get_agg_active_end(p_person_rec.assignment_id,l_tax_ref,l_effective_date) end_date

499:
500: cursor get_agg_start_end_dates is
501: select
502: pay_gb_eoy_archive.get_agg_active_start(p_person_rec.assignment_id,l_tax_ref,l_effective_date) start_date,
503: pay_gb_eoy_archive.get_agg_active_end(p_person_rec.assignment_id,l_tax_ref,l_effective_date) end_date
504: from dual;
505:
506: cursor csr_get_irregular_details is
507: SELECT AEI_INFORMATION3

Line 514: select substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,'TAX_REF'),1,20) tax_ref,

510: AND AEI_INFORMATION_CATEGORY = 'GB_PAY_RTI'
511: AND assignment_id = p_person_rec.assignment_id;
512:
513: cursor csr_parameter_info is
514: select substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,'TAX_REF'),1,20) tax_ref,
515: to_date(substr(pact.legislative_parameters,instr(pact.legislative_parameters,'START=') + 6,10),'YYYY-MM-DD') effective_date
516: from pay_payroll_actions pact,
517: pay_assignment_actions paa
518: where paa.assignment_action_id = p_assactid

Line 1765: select substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,'TAX_REF'),1,20) tax_ref,

1761: lockingactid number;
1762: l_locked_action_id number;
1763: l_exist number;
1764: cursor csr_parameter_info is
1765: select substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,'TAX_REF'),1,20) tax_ref,
1766: to_date(substr(pact.legislative_parameters,instr(pact.legislative_parameters,'START=') + 6,10),'YYYY-MM-DD') effective_date,
1767: business_group_id
1768: from pay_payroll_actions pact
1769: where payroll_action_id = pactid;

Line 2052: select to_number(pay_gb_eoy_archive.get_parameter(legislative_parameters, 'PAYROLL')) payroll_id,

2048: l_locked_action_id number;
2049: l_exist number;
2050: l_exclude_flag char := 'I';
2051: cursor csr_parameter_info is
2052: select to_number(pay_gb_eoy_archive.get_parameter(legislative_parameters, 'PAYROLL')) payroll_id,
2053: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,'TAX_REF'),1,20) tax_ref,
2054: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,'EMPID'),1,20) emp_num,
2055: effective_date,
2056: business_group_id

Line 2053: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,'TAX_REF'),1,20) tax_ref,

2049: l_exist number;
2050: l_exclude_flag char := 'I';
2051: cursor csr_parameter_info is
2052: select to_number(pay_gb_eoy_archive.get_parameter(legislative_parameters, 'PAYROLL')) payroll_id,
2053: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,'TAX_REF'),1,20) tax_ref,
2054: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,'EMPID'),1,20) emp_num,
2055: effective_date,
2056: business_group_id
2057: from pay_payroll_actions

Line 2054: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,'EMPID'),1,20) emp_num,

2050: l_exclude_flag char := 'I';
2051: cursor csr_parameter_info is
2052: select to_number(pay_gb_eoy_archive.get_parameter(legislative_parameters, 'PAYROLL')) payroll_id,
2053: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,'TAX_REF'),1,20) tax_ref,
2054: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,'EMPID'),1,20) emp_num,
2055: effective_date,
2056: business_group_id
2057: from pay_payroll_actions
2058: where payroll_action_id = pactid;

Line 2360: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,'TAX_REF'),1,20) tax_ref

2356: l_pact_id number;
2357:
2358: cursor csr_archive_type is
2359: select report_type,paa.payroll_action_id,
2360: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,'TAX_REF'),1,20) tax_ref
2361: from pay_assignment_actions paa,
2362: pay_payroll_actions ppa
2363: where paa.assignment_action_id = p_assactid
2364: and paa.payroll_action_id = ppa.payroll_action_id;

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

3238: IS
3239:
3240:
3241: cursor csr_parameter_info is
3242: select pay_gb_eoy_archive.get_parameter(legislative_parameters, 'TEST'),
3243: NVL(fnd_date.canonical_to_date(pay_gb_eoy_archive.get_parameter(legislative_parameters, 'START')),sysdate)
3244: from pay_payroll_actions ppa
3245: ,pay_assignment_actions paa
3246: where paa.assignment_action_id = c_assignment_action_id

Line 3243: NVL(fnd_date.canonical_to_date(pay_gb_eoy_archive.get_parameter(legislative_parameters, 'START')),sysdate)

3239:
3240:
3241: cursor csr_parameter_info is
3242: select pay_gb_eoy_archive.get_parameter(legislative_parameters, 'TEST'),
3243: NVL(fnd_date.canonical_to_date(pay_gb_eoy_archive.get_parameter(legislative_parameters, 'START')),sysdate)
3244: from pay_payroll_actions ppa
3245: ,pay_assignment_actions paa
3246: where paa.assignment_action_id = c_assignment_action_id
3247: and ppa.payroll_action_id = paa.payroll_action_id;