DBA Data[Home] [Help]

APPS.PY_ZA_TAX_CERTIFICATES dependencies on PAY_PAYROLL_ACTIONS

Line 141: pay_payroll_actions ppa

137: hr_organization_information hoi,
138: hr_all_organization_units hou,
139: fnd_common_lookups fcl,
140: pay_assignment_actions paa,
141: pay_payroll_actions ppa
142: where ppa.payroll_action_id = substr(P_PAYROLL_ACTION_ID, 28)
143: and ppa.action_type = 'X'
144: and ppa.action_status = 'C'
145: and ppa.report_type = 'ZA_IRP5'

Line 291: From pay_payroll_actions ppa_arch,

287: -- Check whether this is a Lump Sum or a Main Certificate
288:
289: Select decode(count(*), 0 ,'Y', 'N')
290: into l_lump_sum_indicator
291: From pay_payroll_actions ppa_arch,
292: pay_assignment_actions paa_arch
293: where paa_arch.assignment_action_id = p_assignment_action_id
294: and ppa_arch.payroll_action_id = paa_arch.payroll_action_id
295: and paa_arch.assignment_action_id =