DBA Data[Home] [Help]

APPS.PER_ZA_EMPLOYMENT_EQUITY_PKG dependencies on PER_PAY_BASES

Line 1005: per_pay_bases ppb

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'
1009: and ppp.change_date =

Line 5054: from per_pay_bases ppb

5050: begin
5051:
5052: select input_value_id
5053: into l_input_value_id
5054: from per_pay_bases ppb
5055: where ppb.pay_basis_id = l_assignment.pay_basis_id;
5056:
5057:
5058: select nvl(sum(fnd_number.canonical_to_number(prrv.result_value)), 0)

Line 6459: from per_pay_bases ppb

6455: begin
6456:
6457: select input_value_id
6458: into l_input_value_id
6459: from per_pay_bases ppb
6460: where ppb.pay_basis_id = l_assignment.pay_basis_id;
6461:
6462:
6463: select pivff.input_value_id --Pay Value input value ID