DBA Data[Home] [Help]

APPS.PY_ZA_TAX_CERTIFICATES dependencies on PAY_PAYROLL_ACTIONS

Line 144: pay_payroll_actions ppa

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

Line 294: From pay_payroll_actions ppa_arch,

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