DBA Data[Home] [Help]

APPS.PER_AE_WAGE_PROTECTION_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 46: ,pay_assignment_actions paa

42: begin
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

Line 83: pay_assignment_actions paa,

79: begin
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,