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_US_SQWL_ARCHIVE dependencies on FND_DATE

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

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

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

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

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

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

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

231: select /*+ ORDERED */ '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,
235: 'DATE_EARNED=C' , fnd_date.date_to_canonical(pay_magtape_generic.date_earned
236: (PA.effective_date,
237: AA.assignment_id)),
238: 'TRANSFER_WAGE_PLAN_CODE=P',pay_magtape_generic.get_parameter_value
239: ('TRANSFER_WAGE_PLAN_CODE'),

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

405: pay_magtape_generic.get_parameter_value ('TRANSFER_TRANS_LEGAL_CO_ID'),
406: 'JURISDICTION_CODE=C', SR.jurisdiction_code,
407: 'TRANSFER_JD=P', SR.jurisdiction_code,
408: 'ASSIGNMENT_ID=C' , '-1',
409: 'DATE_EARNED=C', fnd_date.date_to_canonical(ppa.effective_date),
410: 'PAYROLL_ACTION_ID=C',
411: pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'),
412: -- 'TRANSFER_2678_FILER=P', HOI.org_information8,
413: 'BUSINESS_GROUP_ID=C' , PPA.business_group_id,

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

438: select distinct
439: 'PAYROLL_ACTION_ID=C', AA.payroll_action_id,
440: 'TAX_UNIT_ID=C' , AA.tax_unit_id,
441: 'TAX_UNIT_ID=P' , AA.tax_unit_id,
442: 'DATE_EARNED=C' , fnd_date.date_to_canonical(PA.effective_date),
443: 'TAX_UNIT_NAME=P' , hou.name
444: from hr_all_organization_units hou,
445: pay_assignment_actions AA,
446: pay_payroll_actions PA

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

457: */ distinct
458: 'PAYROLL_ACTION_ID=C', AA.payroll_action_id,
459: 'TAX_UNIT_ID=C' , AA.tax_unit_id,
460: 'TAX_UNIT_ID=P' , AA.tax_unit_id,
461: 'DATE_EARNED=C' , fnd_date.date_to_canonical(PA.effective_date),
462: 'TAX_UNIT_NAME=P' , hou.name,
463: 'FEIN=P' , hoi.org_information1
464: from hr_all_organization_units hou,
465: hr_organization_information hoi,

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

477: select 'TRANSFER_ASS_ACTION_ID=C', AA.assignment_action_id,
478: 'ASSIGNMENT_ACTION_ID=C' , AA.assignment_action_id,
479: 'ASSIGNMENT_ID=C' , AA.assignment_id,
480: 'ASSIGNMENT_ID=P' , AA.assignment_id, /* Bug 976472 */
481: 'DATE_EARNED=C' ,fnd_date.date_to_canonical(pay_magtape_generic.date_earned(PA.effective_date, AA.assignment_id))
482: from per_all_people_f PE,
483: per_all_assignments_f SS,
484: pay_assignment_actions AA,
485: pay_payroll_actions PA