APPS.PAY_P45_PKG dependencies on PAY_GB_EOY_ARCHIVE

Line 59: 'TEST_INDICATOR=P', decode(pay_gb_eoy_archive.get_parameter

55: -- CURSORS
56: CURSOR csr_tax_district IS
57: SELECT 'SENDER_ID=P', upper(nvl(org_information11,' ')),
58: 'RECEIVER_ID=P', 'INLAND REVENUE',
59: 'TEST_INDICATOR=P', decode(pay_gb_eoy_archive.get_parameter
60: (legislative_parameters,
61: 'TEST'),'Y','1',' '),
62: 'URGENT_MARKER=P', decode(pay_gb_eoy_archive.get_parameter
63: (legislative_parameters,

Line 62: 'URGENT_MARKER=P', decode(pay_gb_eoy_archive.get_parameter

58: 'RECEIVER_ID=P', 'INLAND REVENUE',
59: 'TEST_INDICATOR=P', decode(pay_gb_eoy_archive.get_parameter
60: (legislative_parameters,
61: 'TEST'),'Y','1',' '),
62: 'URGENT_MARKER=P', decode(pay_gb_eoy_archive.get_parameter
63: (legislative_parameters,
64: 'URGENT'),'Y','Y',' '),
65: 'REQUEST_ID=P', fnd_number.number_to_canonical(pact.request_id),
66: 'FORM_TYPE=P', '4',

Line 91: 'CHARS_ALREADY_TESTED=P', pay_gb_eoy_archive.get_parameter

87: --
88: CURSOR csr_edi_assignments IS
89: SELECT
90: 'ASSIGNMENT_ACTION_ID=C', act.assignment_action_id,
91: 'CHARS_ALREADY_TESTED=P', pay_gb_eoy_archive.get_parameter
92: (pact.legislative_parameters,'CHAR_ERROR'),
93: 'ADDRESS_LINE1=P',
94: upper(nvl(max(decode(fue.user_entity_name,
95: 'X_ADDRESS_LINE1',substr(fai.VALUE,1,35))),' ')),

Line 143: GROUP BY act.assignment_action_id, pay_gb_eoy_archive.get_parameter

139: AND pact.payroll_action_id = act.payroll_action_id
140: AND act.assignment_action_id = fai.context1
141: AND fai.archive_type <> 'PA'
142: AND fai.user_entity_id = fue.user_entity_id
143: GROUP BY act.assignment_action_id, pay_gb_eoy_archive.get_parameter
144: (pact.legislative_parameters,'CHAR_ERROR'),
145: act.action_status
146: ORDER BY 12;
147: --

Line 153: 'TEST_INDICATOR=P', decode(pay_gb_eoy_archive.get_parameter

149: /* Added for P45PT1 ( Bug 6345375 ) */
150: CURSOR csr_movded5_tax_district IS
151: SELECT 'SENDER_ID=P', upper(nvl(org_information11,' ')),
152: 'RECEIVER_ID=P' , 'HMRC',
153: 'TEST_INDICATOR=P', decode(pay_gb_eoy_archive.get_parameter
154: (legislative_parameters,
155: 'TEST'),'Y','1',' '),
156: 'URGENT_MARKER=P' , ' ',
157: 'REQUEST_ID=P' , fnd_number.number_to_canonical(pact.request_id),

Line 165: 'TEST_ID=P' , nvl(pay_gb_eoy_archive.get_parameter

161: 'TAX_DIST_REF=P' , upper(substr(ltrim(substr(hoi.org_information1,4,11),'/') ,1,10)), /* Bug no 4086012 */
162: 'TAX_DISTRICT=P' , upper(nvl(substr(hoi.org_information2 ,1,40),' ')),
163: 'EMPLOYERS_ADDRESS_LINE=P', upper(nvl(substr(hoi.org_information4,1,60),' ')),
164: 'EMPLOYERS_NAME=P', upper(nvl(substr(hoi.org_information3,1,36),' ')),
165: 'TEST_ID=P' , nvl(pay_gb_eoy_archive.get_parameter
166: (legislative_parameters,
167: 'TEST_ID'),' ') /*added for P45PT1*/
168: FROM pay_payroll_actions pact,
169: hr_organization_information hoi

Line 184: 'CHARS_ALREADY_TESTED=P', pay_gb_eoy_archive.get_parameter

180: --
181: CURSOR csr_movded5_edi_assignments IS
182: SELECT
183: 'ASSIGNMENT_ACTION_ID=C', act.assignment_action_id,
184: 'CHARS_ALREADY_TESTED=P', pay_gb_eoy_archive.get_parameter
185: (pact.legislative_parameters,'CHAR_ERROR'),
186: 'ADDRESS_LINE1=P',
187: upper(nvl(max(decode(fue.user_entity_name,
188: 'X_ADDRESS_LINE1',substr(fai.VALUE,1,35))),' ')),

Line 240: GROUP BY act.assignment_action_id, pay_gb_eoy_archive.get_parameter

236: AND pact.payroll_action_id = act.payroll_action_id
237: AND act.assignment_action_id = fai.context1
238: AND fai.archive_type <> 'PA'
239: AND fai.user_entity_id = fue.user_entity_id
240: GROUP BY act.assignment_action_id, pay_gb_eoy_archive.get_parameter
241: (pact.legislative_parameters,'CHAR_ERROR'),
242: act.action_status, fnd_date.date_to_canonical(pact.effective_date)
243: ORDER BY 12;
244: /* Addition for P45PT1 ( Bug 6345375 ) ends*/