DBA Data[Home] [Help]

APPS.PAY_NL_CBS_FILE dependencies on PAY_ACTION_INFORMATION

Line 259: pay_action_information pai

255: 'REPORTING_SEQUENCE=P',pai.action_information4,
256: 'PERIODIC_REP_START_DATE=P' ,TO_CHAR(fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('REPORTING_DATE'))-28,'DDMMYYYY')
257: FROM pay_payroll_actions ppa,
258: per_org_structure_versions posv,
259: pay_action_information pai
260: WHERE ppa.payroll_action_id
261: =pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
262: and fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('REPORTING_DATE')) between posv.date_from
263: and nvl(posv.date_to,hr_general.end_of_time)

Line 313: pay_action_information cbs_pai,

309: 'CBS_SI_DAYS_QUARTER=P' ,cbs_pai.action_information23,
310: 'CBS_FOREIGN_WORK=P' ,pap.per_information14
311: FROM
312: pay_assignment_actions pay_act,
313: pay_action_information cbs_pai,
314: per_all_people_f pap,
315: per_all_assignments_f paa,
316: pay_payrolls_f ppf
317: WHERE pay_act.payroll_action_id