DBA Data[Home] [Help]

APPS.PAY_ZA_SOE dependencies on PAY_PAYROLL_ACTIONS

Line 177: ,pay_payroll_actions ppa

173: ,per_jobs_vl job
174: ,pay_assignment_actions paa
175: ,per_assignment_extra_info pae
176: ,per_periods_of_service pps
177: ,pay_payroll_actions ppa
178: ,per_time_periods ptp
179: ,per_time_period_types ptt
180: ,hr_all_organization_units_vl org
181: ,hr_all_organization_units_vl org2

Line 278: ,pay_payroll_actions ppa

274: ,ptp.period_type as COL03 -- Period Type
275: ,fnd_date.date_to_displaydate(ptp.start_date) as COL04 -- Period Start Date
276: ,fnd_date.date_to_displaydate(ptp.end_date) as COL05 -- Period End Date
277: From per_time_periods ptp
278: ,pay_payroll_actions ppa
279: ,pay_assignment_actions paa
280: ,per_time_period_types ptt
281: Where paa.assignment_action_id = ''' || p_assignment_action_id || ''' and
282: paa.payroll_action_id = ppa.payroll_action_id and

Line 521: ,pay_payroll_actions ppa

517: ,pbd.dimension_name as balance_suffix
518: From pay_balance_types pbt
519: ,pay_balance_dimensions pbd
520: ,pay_assignment_actions paa
521: ,pay_payroll_actions ppa
522: ,per_all_assignments_f asg
523: ,hr_organization_information org
524: Where paa.assignment_action_id = p_assignment_action_id and
525: paa.assignment_id = asg.assignment_id and

Line 957: ,pay_payroll_actions ppa

953: ,pay_org_payment_methods_f popmf
954: ,pay_external_accounts pea
955: ,pay_za_branch_cdv_details cdv
956: ,pay_assignment_actions paa
957: ,pay_payroll_actions ppa
958: ,pay_payment_types_tl ppt
959: ,pay_action_interlocks pai
960: Where (pai.locked_action_id = :assignment_action_id or pai.locking_action_id = :assignment_action_id) and
961: paa.assignment_action_id = pai.locking_action_id and