DBA Data[Home] [Help]

APPS.PER_AE_WAGE_PROTECTION_PKG dependencies on PAY_PRE_PAYMENTS_V

Line 85: PAY_PRE_PAYMENTS_V ppv,

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
89: where asg.assignment_id = paa.assignment_id

Line 109: from PAY_PRE_PAYMENTS_V ppv1

105: and paa.assignment_action_id = ppv.prepay_action_id
106: and ppv.business_group_id = p_business_group_id
107: and ppv.value > 0
108: and 'Paid' =ALL (select ppv1.status
109: from PAY_PRE_PAYMENTS_V ppv1
110: where ppv1.prepay_action_id = paa.assignment_action_id);
111: return l_cnt_emp_paid;
112: end get_number_of_emps_paid;
113: