APPS.PER_ZA_EMPLOYMENT_EQUITY_PKG dependencies on PER_PAY_PROPOSALS

Line 1004: from per_pay_proposals ppp,

1000: begin
1001:
1002: select ppp.proposed_salary_n * ppb.pay_annualization_factor
1003: into g_assignments_table(l_assignment.assignment_id).annual_income
1004: from per_pay_proposals ppp,
1005: per_pay_bases ppb
1006: where ppb.pay_basis_id = l_assignment.pay_basis_id
1007: and ppp.assignment_id = l_assignment.assignment_id
1008: and ppp.approved = 'Y'

Line 1012: from per_pay_proposals ppp2

1008: and ppp.approved = 'Y'
1009: and ppp.change_date =
1010: (
1011: select max(ppp2.change_date)
1012: from per_pay_proposals ppp2
1013: where ppp2.assignment_id = l_assignment.assignment_id
1014: and ppp2.change_date <= p_report_date
1015: and ppp2.approved = 'Y'
1016: );