DBA Data[Home] [Help]

APPS.PER_ZA_EMPLOYMENT_EQUITY_PKG dependencies on PER_PAY_BASES

Line 958: per_pay_bases ppb

954:
955: select ppp.proposed_salary_n * ppb.pay_annualization_factor
956: into g_assignments_table(l_assignment.assignment_id).annual_income
957: from per_pay_proposals ppp,
958: per_pay_bases ppb
959: where ppb.pay_basis_id = l_assignment.pay_basis_id
960: and ppp.assignment_id = l_assignment.assignment_id
961: and ppp.approved = 'Y'
962: and ppp.change_date =

Line 4922: per_pay_bases ppb

4918:
4919: select ppp.proposed_salary_n * ppb.pay_annualization_factor
4920: into g_assignments_table(l_assignment.assignment_id).annual_income
4921: from per_pay_proposals ppp,
4922: per_pay_bases ppb
4923: where ppb.pay_basis_id = l_assignment.pay_basis_id
4924: and ppp.assignment_id = l_assignment.assignment_id
4925: and ppp.approved = 'Y'
4926: and ppp.change_date =