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

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

64: -- CURSORS
65: CURSOR csr_tax_district IS
66: SELECT 'SENDER_ID=P', upper(nvl(org_information11,' ')),
67: 'RECEIVER_ID=P', 'INLAND REVENUE',
68: 'TEST_INDICATOR=P', decode(pay_gb_eoy_archive.get_parameter
69: (legislative_parameters,
70: 'TEST'),'Y','1',' '),
71: 'URGENT_MARKER=P', decode(pay_gb_eoy_archive.get_parameter
72: (legislative_parameters,

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

67: 'RECEIVER_ID=P', 'INLAND REVENUE',
68: 'TEST_INDICATOR=P', decode(pay_gb_eoy_archive.get_parameter
69: (legislative_parameters,
70: 'TEST'),'Y','1',' '),
71: 'URGENT_MARKER=P', decode(pay_gb_eoy_archive.get_parameter
72: (legislative_parameters,
73: 'URGENT'),'Y','Y',' '),
74: 'REQUEST_ID=P', fnd_number.number_to_canonical(pact.request_id),
75: 'FORM_TYPE=P', '4',

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

96: --
97: CURSOR csr_edi_assignments IS
98: SELECT
99: 'ASSIGNMENT_ACTION_ID=C', act.assignment_action_id,
100: 'CHARS_ALREADY_TESTED=P', pay_gb_eoy_archive.get_parameter
101: (pact.legislative_parameters,'CHAR_ERROR'),
102: 'ADDRESS_LINE1=P',
103: upper(nvl(max(decode(fue.user_entity_name,
104: 'X_ADDRESS_LINE1',substr(fai.VALUE,1,35))),' ')),

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

148: AND pact.payroll_action_id = act.payroll_action_id
149: AND act.assignment_action_id = fai.context1
150: AND fai.archive_type <> 'PA'
151: AND fai.user_entity_id = fue.user_entity_id
152: GROUP BY act.assignment_action_id, pay_gb_eoy_archive.get_parameter
153: (pact.legislative_parameters,'CHAR_ERROR'),
154: act.action_status
155: ORDER BY 12;
156: --

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

158: /* Added for P45PT1 ( Bug 6345375 ) */
159: CURSOR csr_movded5_tax_district IS
160: SELECT 'SENDER_ID=P', upper(nvl(org_information11,' ')),
161: 'RECEIVER_ID=P' , 'HMRC',
162: 'TEST_INDICATOR=P', decode(pay_gb_eoy_archive.get_parameter
163: (legislative_parameters,
164: 'TEST'),'Y','1',' '),
165: 'URGENT_MARKER=P' , ' ',
166: 'REQUEST_ID=P' , fnd_number.number_to_canonical(pact.request_id),

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

170: 'TAX_DIST_REF=P' , upper(substr(ltrim(substr(hoi.org_information1,4,11),'/') ,1,10)), /* Bug no 4086012 */
171: 'TAX_DISTRICT=P' , upper(nvl(substr(hoi.org_information2 ,1,40),' ')),
172: 'EMPLOYERS_ADDRESS_LINE=P', upper(nvl(substr(hoi.org_information4,1,60),' ')),
173: 'EMPLOYERS_NAME=P', upper(nvl(substr(hoi.org_information3,1,36),' ')),
174: 'TEST_ID=P' , nvl(pay_gb_eoy_archive.get_parameter
175: (legislative_parameters,
176: 'TEST_ID'),' ') /*added for P45PT1*/
177: FROM pay_payroll_actions pact,
178: hr_organization_information hoi

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

189: --
190: CURSOR csr_movded5_edi_assignments IS
191: SELECT
192: 'ASSIGNMENT_ACTION_ID=C', act.assignment_action_id,
193: 'CHARS_ALREADY_TESTED=P', pay_gb_eoy_archive.get_parameter
194: (pact.legislative_parameters,'CHAR_ERROR'),
195: 'ADDRESS_LINE1=P',
196: upper(nvl(max(decode(fue.user_entity_name,
197: 'X_ADDRESS_LINE1',substr(fai.VALUE,1,35))),' ')),

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

245: AND pact.payroll_action_id = act.payroll_action_id
246: AND act.assignment_action_id = fai.context1
247: AND fai.archive_type <> 'PA'
248: AND fai.user_entity_id = fue.user_entity_id
249: GROUP BY act.assignment_action_id, pay_gb_eoy_archive.get_parameter
250: (pact.legislative_parameters,'CHAR_ERROR'),
251: act.action_status, fnd_date.date_to_canonical(pact.effective_date)
252: ORDER BY 12;
253: /* Addition for P45PT1 ( Bug 6345375 ) ends*/

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

255: /* Added for P45PT1 Ver6 changes starts */
256: CURSOR csr_movded_ver6_tax_district IS
257: SELECT 'SENDER_ID=P', upper(nvl(org_information11,' ')),
258: 'RECEIVER_ID=P' , 'HMRC',
259: 'TEST_INDICATOR=P', decode(pay_gb_eoy_archive.get_parameter
260: (legislative_parameters,
261: 'TEST'),'Y','1',' '),
262: 'URGENT_MARKER=P' , ' ',
263: 'REQUEST_ID=P' , fnd_number.number_to_canonical(pact.request_id),

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

267: 'TAX_DIST_REF=P' , upper(substr(ltrim(substr(hoi.org_information1,4,11),'/') ,1,10)),
268: 'TAX_DISTRICT=P' , upper(nvl(substr(hoi.org_information2 ,1,40),' ')),
269: 'EMPLOYERS_ADDRESS_LINE=P', upper(nvl(substr(hoi.org_information4,1,60),' ')),
270: 'EMPLOYERS_NAME=P', upper(nvl(substr(hoi.org_information3,1,36),' ')),
271: 'TEST_ID=P' , nvl(pay_gb_eoy_archive.get_parameter
272: (legislative_parameters,
273: 'TEST_ID'),' ') /*added for P45PT1*/
274: FROM pay_payroll_actions pact,
275: hr_organization_information hoi

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

286: --
287: CURSOR csr_movded_ver6_edi_assignment IS
288: SELECT
289: 'ASSIGNMENT_ACTION_ID=C', act.assignment_action_id,
290: 'CHARS_ALREADY_TESTED=P', pay_gb_eoy_archive.get_parameter
291: (pact.legislative_parameters,'CHAR_ERROR'),
292: 'ADDRESS_LINE1=P',
293: upper(nvl(max(decode(fue.user_entity_name,
294: 'X_ADDRESS_LINE1',substr(fai.VALUE,1,35))),' ')),

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

342: AND pact.payroll_action_id = act.payroll_action_id
343: AND act.assignment_action_id = fai.context1
344: AND fai.archive_type <> 'PA'
345: AND fai.user_entity_id = fue.user_entity_id
346: GROUP BY act.assignment_action_id, pay_gb_eoy_archive.get_parameter
347: (pact.legislative_parameters,'CHAR_ERROR'),
348: act.action_status, fnd_date.date_to_canonical(pact.effective_date)
349: ORDER BY 12;
350: --