DBA Data[Home] [Help]

APPS.PER_AE_WAGE_PROTECTION_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 47: ,pay_payroll_actions ppa

43: SELECT count(distinct asg.assignment_id)
44: into l_cnt_emps
45: FROM per_all_assignments_f asg
46: ,pay_assignment_actions paa
47: ,pay_payroll_actions ppa
48: ,hr_soft_coding_keyflex hscl
49: ,per_periods_of_service pos
50: ,per_all_people_f ppf
51: WHERE asg.assignment_id = paa.assignment_id

Line 84: pay_payroll_actions ppa,

80: select count(distinct asg.assignment_id), NVL(sum(ppv.value),0)
81: into l_cnt_emp_paid, l_amt_paid
82: from per_all_assignments_f asg,
83: pay_assignment_actions paa,
84: pay_payroll_actions ppa,
85: PAY_PRE_PAYMENTS_V ppv,
86: hr_soft_coding_keyflex hscl,
87: per_periods_of_service pos,
88: per_all_people_f ppf