APPS.PAY_US_PSD_XML dependencies on PAY_US_ASG_REPORTING

Line 149: pay_us_asg_reporting puar

145: pay_payroll_actions ppa,
146: pay_assignment_actions aa,
147: hr_organization_information hoi,
148: per_all_assignments_f paf,
149: pay_us_asg_reporting puar
150: WHERE aa.payroll_action_id = pay_magtape_generic.get_parameter_value
151: ('TRANSFER_PAYROLL_ACTION_ID')
152: AND ppa.report_type = 'PSD_MAG_XML'
153: AND to_char(ppa.effective_date, 'YYYY') =

Line 178: pay_us_asg_reporting puar

174: pay_payroll_actions ppa,
175: pay_assignment_actions aa,
176: per_all_assignments_f paf,--Added for the Bug 15944697
177: hr_organization_information hoi,
178: pay_us_asg_reporting puar
179: WHERE aa.payroll_action_id = pay_magtape_generic.get_parameter_value
180: ('TRANSFER_PAYROLL_ACTION_ID')
181: AND ppa.report_type = 'PSD_MAG_XML'
182: AND to_char(ppa.effective_date, 'YYYY') =

Line 207: pay_us_asg_reporting puar

203: pay_payroll_actions ppa,
204: pay_assignment_actions aa,
205: per_all_assignments_f paf,--Added for the Bug 15944697
206: hr_organization_information hoi,
207: pay_us_asg_reporting puar
208: WHERE aa.payroll_action_id = pay_magtape_generic.get_parameter_value
209: ('TRANSFER_PAYROLL_ACTION_ID')
210: AND ppa.report_type = 'YREND'
211: AND to_char(ppa.effective_date, 'YYYY') =

Line 246: pay_us_asg_reporting puar

242: FROM per_all_people_f PE,
243: per_all_assignments_f SS,
244: pay_assignment_actions AA,
245: pay_payroll_actions PA ,
246: pay_us_asg_reporting puar
247: WHERE PA.payroll_action_id = pay_magtape_generic.get_parameter_value
248: ('TRANSFER_PAYROLL_ACTION_ID')
249: AND AA.payroll_action_id = PA.payroll_action_id
250: AND AA.tax_unit_id = pay_magtape_generic.get_parameter_value

Line 261: /* and exists (select 1 from pay_us_asg_reporting puar

257: AND pay_magtape_generic.date_earned(PA.effective_date,SS.assignment_id)
258: BETWEEN PE.effective_start_date and PE.effective_end_date
259: AND puar.assignment_id = SS.assignment_id
260: AND substr(puar.jurisdiction_code, 11, 6) = pay_magtape_generic.get_parameter_value('ER_PSD_CODE');
261: /* and exists (select 1 from pay_us_asg_reporting puar
262: where puar.assignment_id = SS.assignment_id
263: and substr(puar.jurisdiction_code, 11, 6) = pay_magtape_generic.get_parameter_value('ER_PSD_CODE')
264: )*/
265:

Line 274: FROM pay_us_asg_reporting puar,

270:
271: /*SELECT DISTINCT 'TRANSFER_ACT_ID=P',
272: pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID'),
273: 'TRANSFER_EE_JD_CODE=P', puar.jurisdiction_code
274: FROM pay_us_asg_reporting puar,
275: pay_assignment_actions paa
276: WHERE puar.assignment_id=paa.assignment_id
277: AND paa.assignment_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')
278: AND length(puar.jurisdiction_code)=16

Line 295: FROM pay_us_asg_reporting puar,

291:
292: SELECT DISTINCT 'TRANSFER_ACT_ID=P',
293: pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID'),
294: 'TRANSFER_EE_JD_CODE=P', puar.jurisdiction_code
295: FROM pay_us_asg_reporting puar,
296: pay_assignment_actions paa,
297: per_all_people_f pap,
298: per_all_assignments_f paf,
299: pay_payroll_actions ppa