eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_ZA_EMPLOYMENT_EQUITY_PKG dependencies on PER_PAY_PROPOSALS

Line 957: from per_pay_proposals ppp,

953: begin
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'

Line 965: from per_pay_proposals ppp2

961: and ppp.approved = 'Y'
962: and ppp.change_date =
963: (
964: select max(ppp2.change_date)
965: from per_pay_proposals ppp2
966: where ppp2.assignment_id = l_assignment.assignment_id
967: and ppp2.change_date <= p_report_date
968: and ppp2.approved = 'Y'
969: );

Line 4921: from per_pay_proposals ppp,

4917: begin
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'

Line 4929: from per_pay_proposals ppp2

4925: and ppp.approved = 'Y'
4926: and ppp.change_date =
4927: (
4928: select max(ppp2.change_date)
4929: from per_pay_proposals ppp2
4930: where ppp2.assignment_id = l_assignment.assignment_id
4931: and ppp2.change_date <= p_report_date
4932: and ppp2.approved = 'Y'
4933: );