DBA Data[Home] [Help]

APPS.PAY_ZA_IRP5_MAGTAPE_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 59: from pay_payroll_actions ppa,

55: and hloc.location_id (+) = haou.location_id
56: and exists
57: (
58: select ''
59: from pay_payroll_actions ppa,
60: pay_assignment_actions paa,
61: per_assignment_extra_info paei
62: where ppa.payroll_action_id =
63: nvl(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'),

Line 114: from pay_payroll_actions ppa,

110: 'PERSON_ID=C', pef.person_id,
111: 'DATE_EARNED=C', fnd_date.date_to_canonical(ppa.effective_date),
112: 'PAYROLL_ID=C', pef.payroll_id,
113: 'SOURCE_TEXT=C', nvl(faidn.context,'To Be Advised')
114: from pay_payroll_actions ppa,
115: hr_soft_coding_keyflex scl,
116: pay_all_payrolls_f papf,
117: per_assignments_f pef,
118: per_people_f ppf,