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

Line 156: l_proc VARCHAR2(100) := 'pay_gb_eoy_archive.remove_null_address_lines';

152: --
153: TYPE t_lines IS TABLE OF VARCHAR2(1000) INDEX BY BINARY_INTEGER;
154: l_lines t_lines;
155: l_dummy VARCHAR2(1000);
156: l_proc VARCHAR2(100) := 'pay_gb_eoy_archive.remove_null_address_lines';
157: --
158: BEGIN
159: hr_utility.set_location('Entering: '||l_proc,1);
160: hr_utility.trace('p_address_line1='||p_address_line1);

Line 208: SELECT to_number(pay_gb_eoy_archive.get_parameter(legislative_parameters, 'PAYROLL_ID')) payroll_id,

204: IS
205:
206: CURSOR csr_parameter_info
207: IS
208: SELECT to_number(pay_gb_eoy_archive.get_parameter(legislative_parameters, 'PAYROLL_ID')) payroll_id,
209: SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'TAX_REF'),1,20) tax_ref,
210: effective_date eff_date,
211: business_group_id bg_id
212: FROM pay_payroll_actions pact

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

205:
206: CURSOR csr_parameter_info
207: IS
208: SELECT to_number(pay_gb_eoy_archive.get_parameter(legislative_parameters, 'PAYROLL_ID')) payroll_id,
209: SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'TAX_REF'),1,20) tax_ref,
210: effective_date eff_date,
211: business_group_id bg_id
212: FROM pay_payroll_actions pact
213: WHERE payroll_action_id = p_pactid;

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

666:
667:
668: CURSOR csr_parameter_info
669: IS
670: SELECT SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'TAX_REF'),1,20) tax_ref
671: FROM pay_payroll_actions pact
672: WHERE payroll_action_id = p_pactid;
673:
674: CURSOR get_asg_active_range(p_asg_id NUMBER, p_tax_ref VARCHAR2) IS

Line 3060: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,

3056: SELECT
3057: -- to_date('06/04/'||to_char(start_date,'YYYY'),'dd/mm/yyyy') start_year,
3058: -- effective_date end_year,
3059: business_group_id,
3060: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,
3061: 'PERMIT'),1,12) permit,
3062: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,
3063: 'TAX_REF'),1,3) tax_dist,
3064: substr(ltrim(substr(pay_gb_eoy_archive.get_parameter(

Line 3062: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,

3058: -- effective_date end_year,
3059: business_group_id,
3060: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,
3061: 'PERMIT'),1,12) permit,
3062: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,
3063: 'TAX_REF'),1,3) tax_dist,
3064: substr(ltrim(substr(pay_gb_eoy_archive.get_parameter(
3065: legislative_parameters,'TAX_REF'),4,11),'/'),1,10) tax_ref, -- 4011263: tax ref can be 10 chars long
3066: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,

Line 3064: substr(ltrim(substr(pay_gb_eoy_archive.get_parameter(

3060: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,
3061: 'PERMIT'),1,12) permit,
3062: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,
3063: 'TAX_REF'),1,3) tax_dist,
3064: substr(ltrim(substr(pay_gb_eoy_archive.get_parameter(
3065: legislative_parameters,'TAX_REF'),4,11),'/'),1,10) tax_ref, -- 4011263: tax ref can be 10 chars long
3066: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,
3067: 'TEST'),1,1) test_indicator,
3068: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,

Line 3066: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,

3062: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,
3063: 'TAX_REF'),1,3) tax_dist,
3064: substr(ltrim(substr(pay_gb_eoy_archive.get_parameter(
3065: legislative_parameters,'TAX_REF'),4,11),'/'),1,10) tax_ref, -- 4011263: tax ref can be 10 chars long
3066: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,
3067: 'TEST'),1,1) test_indicator,
3068: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,
3069: 'UNIQUE_TEST_ID'),1,8) unique_test_id
3070: FROM pay_payroll_actions

Line 3068: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,

3064: substr(ltrim(substr(pay_gb_eoy_archive.get_parameter(
3065: legislative_parameters,'TAX_REF'),4,11),'/'),1,10) tax_ref, -- 4011263: tax ref can be 10 chars long
3066: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,
3067: 'TEST'),1,1) test_indicator,
3068: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,
3069: 'UNIQUE_TEST_ID'),1,8) unique_test_id
3070: FROM pay_payroll_actions
3071: WHERE payroll_action_id = p_pact_id;
3072:

Line 3226: SELECT --to_number(pay_gb_eoy_archive.get_parameter(legislative_parameters, 'PAYROLL_ID')) payroll_id,

3222: l_asg_set_id number;
3223:
3224: CURSOR csr_parameter_info
3225: IS
3226: SELECT --to_number(pay_gb_eoy_archive.get_parameter(legislative_parameters, 'PAYROLL_ID')) payroll_id,
3227: SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'TAX_REF'),1,20) tax_ref,
3228: -- SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'FIRST_FPS'),1,1) first_fps,
3229: effective_date,
3230: business_group_id,

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

3223:
3224: CURSOR csr_parameter_info
3225: IS
3226: SELECT --to_number(pay_gb_eoy_archive.get_parameter(legislative_parameters, 'PAYROLL_ID')) payroll_id,
3227: SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'TAX_REF'),1,20) tax_ref,
3228: -- SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'FIRST_FPS'),1,1) first_fps,
3229: effective_date,
3230: business_group_id,
3231: SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'ASG_SET'),1,20) asg_set_id

Line 3228: -- SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'FIRST_FPS'),1,1) first_fps,

3224: CURSOR csr_parameter_info
3225: IS
3226: SELECT --to_number(pay_gb_eoy_archive.get_parameter(legislative_parameters, 'PAYROLL_ID')) payroll_id,
3227: SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'TAX_REF'),1,20) tax_ref,
3228: -- SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'FIRST_FPS'),1,1) first_fps,
3229: effective_date,
3230: business_group_id,
3231: SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'ASG_SET'),1,20) asg_set_id
3232: -- fnd_date.canonical_to_date(SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'FIRST_FPS_DATE'),1,10)) first_fps_date

Line 3231: SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'ASG_SET'),1,20) asg_set_id

3227: SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'TAX_REF'),1,20) tax_ref,
3228: -- SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'FIRST_FPS'),1,1) first_fps,
3229: effective_date,
3230: business_group_id,
3231: SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'ASG_SET'),1,20) asg_set_id
3232: -- fnd_date.canonical_to_date(SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'FIRST_FPS_DATE'),1,10)) first_fps_date
3233: FROM pay_payroll_actions pact
3234: WHERE payroll_action_id = pactid;
3235:

Line 3232: -- fnd_date.canonical_to_date(SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'FIRST_FPS_DATE'),1,10)) first_fps_date

3228: -- SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'FIRST_FPS'),1,1) first_fps,
3229: effective_date,
3230: business_group_id,
3231: SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'ASG_SET'),1,20) asg_set_id
3232: -- fnd_date.canonical_to_date(SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'FIRST_FPS_DATE'),1,10)) first_fps_date
3233: FROM pay_payroll_actions pact
3234: WHERE payroll_action_id = pactid;
3235:
3236: CURSOR csr_asg(c_asg_id NUMBER, c_effective_date DATE)

Line 3621: SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'PRE_PAY_ID'),1,20) pre_pay_id,

3617: CURSOR csr_parameter_info(p_payroll_action_id NUMBER)
3618: IS
3619: SELECT effective_date,
3620: business_group_id,
3621: SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'PRE_PAY_ID'),1,20) pre_pay_id,
3622: SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'PAYROLL_ID'),1,20) payroll_id,
3623: SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'TAX_REF'),1,20) tax_ref,
3624: SUBSTR(pay_gb_eoy_archive.get_parameter (legislative_parameters, 'FIRST_FPS'), 1,1) first_fps
3625:

Line 3622: SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'PAYROLL_ID'),1,20) payroll_id,

3618: IS
3619: SELECT effective_date,
3620: business_group_id,
3621: SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'PRE_PAY_ID'),1,20) pre_pay_id,
3622: SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'PAYROLL_ID'),1,20) payroll_id,
3623: SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'TAX_REF'),1,20) tax_ref,
3624: SUBSTR(pay_gb_eoy_archive.get_parameter (legislative_parameters, 'FIRST_FPS'), 1,1) first_fps
3625:
3626: FROM pay_payroll_actions

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

3619: SELECT effective_date,
3620: business_group_id,
3621: SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'PRE_PAY_ID'),1,20) pre_pay_id,
3622: SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'PAYROLL_ID'),1,20) payroll_id,
3623: SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'TAX_REF'),1,20) tax_ref,
3624: SUBSTR(pay_gb_eoy_archive.get_parameter (legislative_parameters, 'FIRST_FPS'), 1,1) first_fps
3625:
3626: FROM pay_payroll_actions
3627: WHERE payroll_action_id = p_payroll_action_id;

Line 3624: SUBSTR(pay_gb_eoy_archive.get_parameter (legislative_parameters, 'FIRST_FPS'), 1,1) first_fps

3620: business_group_id,
3621: SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'PRE_PAY_ID'),1,20) pre_pay_id,
3622: SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'PAYROLL_ID'),1,20) payroll_id,
3623: SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'TAX_REF'),1,20) tax_ref,
3624: SUBSTR(pay_gb_eoy_archive.get_parameter (legislative_parameters, 'FIRST_FPS'), 1,1) first_fps
3625:
3626: FROM pay_payroll_actions
3627: WHERE payroll_action_id = p_payroll_action_id;
3628:

Line 3899: --to_number(pay_gb_eoy_archive.get_parameter(legislative_parameters, 'PAYROLL_ID')) payroll_id,

3895:
3896: CURSOR csr_parameter_info
3897: IS
3898: SELECT
3899: --to_number(pay_gb_eoy_archive.get_parameter(legislative_parameters, 'PAYROLL_ID')) payroll_id,
3900: SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'TAX_REF'),1,20) tax_ref,
3901: effective_date eff_date,
3902: business_group_id bg_id,
3903: pact.payroll_action_id pactid

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

3896: CURSOR csr_parameter_info
3897: IS
3898: SELECT
3899: --to_number(pay_gb_eoy_archive.get_parameter(legislative_parameters, 'PAYROLL_ID')) payroll_id,
3900: SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'TAX_REF'),1,20) tax_ref,
3901: effective_date eff_date,
3902: business_group_id bg_id,
3903: pact.payroll_action_id pactid
3904: FROM pay_payroll_actions pact,

Line 4558: and ppf.payroll_id = SUBSTR(pay_gb_eoy_archive.get_parameter(ppa.legislative_parameters,'PAYROLL_ID'),1,20)

4554: IS
4555: SELECT ppf.PAYROLL_NAME , ppapre.EFFECTIVE_DATE
4556: from pay_payrolls_f ppf,pay_payroll_actions ppapre,pay_payroll_actions ppa
4557: WHERE ppa.payroll_action_id = pactid
4558: and ppf.payroll_id = SUBSTR(pay_gb_eoy_archive.get_parameter(ppa.legislative_parameters,'PAYROLL_ID'),1,20)
4559: and ppapre.payroll_action_id = SUBSTR(pay_gb_eoy_archive.get_parameter(ppa.legislative_parameters,'PRE_PAY_ID'),1,20);
4560:
4561: -- Cursor to fetch Errored Records
4562: CURSOR get_asg_action_id_error

Line 4559: and ppapre.payroll_action_id = SUBSTR(pay_gb_eoy_archive.get_parameter(ppa.legislative_parameters,'PRE_PAY_ID'),1,20);

4555: SELECT ppf.PAYROLL_NAME , ppapre.EFFECTIVE_DATE
4556: from pay_payrolls_f ppf,pay_payroll_actions ppapre,pay_payroll_actions ppa
4557: WHERE ppa.payroll_action_id = pactid
4558: and ppf.payroll_id = SUBSTR(pay_gb_eoy_archive.get_parameter(ppa.legislative_parameters,'PAYROLL_ID'),1,20)
4559: and ppapre.payroll_action_id = SUBSTR(pay_gb_eoy_archive.get_parameter(ppa.legislative_parameters,'PRE_PAY_ID'),1,20);
4560:
4561: -- Cursor to fetch Errored Records
4562: CURSOR get_asg_action_id_error
4563: IS