APPS.PAY_US_SQWL_ARCHIVE dependencies on FND_DATE

Line 97: 'DATE_EARNED=C' ,fnd_date.date_to_canonical(PA.effective_date),

93: 'PAYROLL_ACTION_ID=C', AA.payroll_action_id,
94: 'TAX_UNIT_ID=C' , AA.tax_unit_id,
95: 'TAX_UNIT_ID=P' , AA.tax_unit_id,
96: 'JURISDICTION_CODE=C', SR.jurisdiction_code,
97: 'DATE_EARNED=C' ,fnd_date.date_to_canonical(PA.effective_date),
98: 'BUSINESS_GROUP_ID=C', PA.business_group_id,
99: 'TRANSFER_BUSINESS_GROUP_ID=P', PA.business_group_id
100: from pay_state_rules SR,
101: pay_assignment_actions AA,

Line 127: 'DATE_EARNED=C' , fnd_date.date_to_canonical(PA.effective_date),

123: 'PAYROLL_ACTION_ID=C', AA.payroll_action_id,
124: 'TAX_UNIT_ID=C' , AA.tax_unit_id,
125: 'TAX_UNIT_ID=P' , AA.tax_unit_id,
126: 'JURISDICTION_CODE=C', SR.jurisdiction_code,
127: 'DATE_EARNED=C' , fnd_date.date_to_canonical(PA.effective_date),
128: 'BUSINESS_GROUP_ID=C', PA.business_group_id,
129: 'TRANSFER_COMPANY_SUI_ID=P', hoi.org_information2,
130: 'TRANSFER_WAGE_PLAN_CODE=P', hoi.org_information3,
131: 'TRANSFER_REPORT_FORMAT=P', pay_magtape_generic.get_parameter_value

Line 194: 'DATE_EARNED=C' ,fnd_date.date_to_canonical(pay_magtape_generic.date_earned

190: select 'TRANSFER_ASS_ACTION_ID=C', AA.assignment_action_id,
191: 'ASSIGNMENT_ACTION_ID=C' , AA.assignment_action_id,
192: 'ASSIGNMENT_ID=C' , AA.assignment_id,
193: 'ASSIGNMENT_ID=P' , AA.assignment_id, /* Bug 976472 */
194: 'DATE_EARNED=C' ,fnd_date.date_to_canonical(pay_magtape_generic.date_earned
195: (PA.effective_date, AA.assignment_id))
196: from per_all_people_f PE,
197: per_all_assignments_f SS,
198: pay_assignment_actions AA,

Line 235: 'DATE_EARNED=C' ,fnd_date.date_to_canonical(pay_magtape_generic.date_earned

231: select 'TRANSFER_ASS_ACTION_ID=C', AA.assignment_action_id,
232: 'ASSIGNMENT_ACTION_ID=C' , AA.assignment_action_id,
233: 'ASSIGNMENT_ID=C' , AA.assignment_id,
234: 'ASSIGNMENT_ID=P' , AA.assignment_id, /* Bug 976472 */
235: 'DATE_EARNED=C' ,fnd_date.date_to_canonical(pay_magtape_generic.date_earned
236: (PA.effective_date, AA.assignment_id))
237: from per_all_people_f PE,
238: per_all_assignments_f SS,
239: pay_assignment_actions AA,

Line 272: 'DATE_EARNED=C' , fnd_date.date_to_canonical(pay_magtape_generic.date_earned

268: select /*+ ORDERED */ 'TRANSFER_ASS_ACTION_ID=C', AA.assignment_action_id,
269: 'ASSIGNMENT_ACTION_ID=C' , AA.assignment_action_id,
270: 'ASSIGNMENT_ID=C' , AA.assignment_id,
271: 'ASSIGNMENT_ID=P' , AA.assignment_id,
272: 'DATE_EARNED=C' , fnd_date.date_to_canonical(pay_magtape_generic.date_earned
273: (PA.effective_date,
274: AA.assignment_id)),
275: 'TRANSFER_WAGE_PLAN_CODE=P',pay_magtape_generic.get_parameter_value
276: ('TRANSFER_WAGE_PLAN_CODE'),

Line 446: 'DATE_EARNED=C', fnd_date.date_to_canonical(ppa.effective_date),

442: pay_magtape_generic.get_parameter_value ('TRANSFER_TRANS_LEGAL_CO_ID'),
443: 'JURISDICTION_CODE=C', SR.jurisdiction_code,
444: 'TRANSFER_JD=P', SR.jurisdiction_code,
445: 'ASSIGNMENT_ID=C' , '-1',
446: 'DATE_EARNED=C', fnd_date.date_to_canonical(ppa.effective_date),
447: 'PAYROLL_ACTION_ID=C',
448: pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'),
449: -- 'TRANSFER_2678_FILER=P', HOI.org_information8,
450: 'BUSINESS_GROUP_ID=C' , PPA.business_group_id,

Line 479: 'DATE_EARNED=C' , fnd_date.date_to_canonical(PA.effective_date),

475: select distinct
476: 'PAYROLL_ACTION_ID=C', AA.payroll_action_id,
477: 'TAX_UNIT_ID=C' , AA.tax_unit_id,
478: 'TAX_UNIT_ID=P' , AA.tax_unit_id,
479: 'DATE_EARNED=C' , fnd_date.date_to_canonical(PA.effective_date),
480: 'TAX_UNIT_NAME=P' , substr(hou.name,1,81)
481: from hr_all_organization_units hou,
482: pay_assignment_actions AA,
483: pay_payroll_actions PA

Line 500: 'DATE_EARNED=C' , fnd_date.date_to_canonical(PA.effective_date),

496: */ distinct
497: 'PAYROLL_ACTION_ID=C', AA.payroll_action_id,
498: 'TAX_UNIT_ID=C' , AA.tax_unit_id,
499: 'TAX_UNIT_ID=P' , AA.tax_unit_id,
500: 'DATE_EARNED=C' , fnd_date.date_to_canonical(PA.effective_date),
501: 'TAX_UNIT_NAME=P' , hou.name,
502: 'FEIN=P' , hoi.org_information1
503: from hr_all_organization_units hou,
504: hr_organization_information hoi,

Line 520: 'DATE_EARNED=C' ,fnd_date.date_to_canonical(pay_magtape_generic.date_earned(PA.effective_date, AA.assignment_id))

516: select 'TRANSFER_ASS_ACTION_ID=C', AA.assignment_action_id,
517: 'ASSIGNMENT_ACTION_ID=C' , AA.assignment_action_id,
518: 'ASSIGNMENT_ID=C' , AA.assignment_id,
519: 'ASSIGNMENT_ID=P' , AA.assignment_id, /* Bug 976472 */
520: 'DATE_EARNED=C' ,fnd_date.date_to_canonical(pay_magtape_generic.date_earned(PA.effective_date, AA.assignment_id))
521: from per_all_people_f PE,
522: per_all_assignments_f SS,
523: pay_assignment_actions AA,
524: pay_payroll_actions PA