APPS.PER_SALADMIN_UTILITY dependencies on PAY_INPUT_VALUES_F

Line 62: ,pay_input_values_f piv

58: ,PER_SALADMIN_UTILITY.get_grade_currency(paa.grade_id,ppb.rate_id,p_effective_date,paa.business_group_id) as grade_rate_currency_code
59: ,ben_cwb_person_info_pkg.get_grd_min_val(paa.grade_id,ppb.rate_id,p_effective_date)
60: from per_all_assignments_f paa
61: ,per_pay_bases ppb
62: ,pay_input_values_f piv
63: ,pay_element_types_f pet
64: where paa.assignment_id = p_assignment_id
65: and paa.pay_basis_id = ppb.pay_basis_id
66: and ppb.input_value_id = piv.input_value_id

Line 120: ,pay_input_values_f piv

116: ,PER_SALADMIN_UTILITY.get_grade_currency(paa.grade_id,ppb.rate_id,p_effective_date,paa.business_group_id) as grade_rate_currency_code
117: ,ben_cwb_person_info_pkg.get_grd_max_val(paa.grade_id,ppb.rate_id,p_effective_date)
118: from per_all_assignments_f paa
119: ,per_pay_bases ppb
120: ,pay_input_values_f piv
121: ,pay_element_types_f pet
122: where paa.assignment_id = p_assignment_id
123: and paa.pay_basis_id = ppb.pay_basis_id
124: and ppb.input_value_id = piv.input_value_id

Line 242: l_uom pay_input_values_f.uom%TYPE;

238:
239: FUNCTION get_uom(p_pay_proposal_id IN NUMBER)
240: RETURN VARCHAR2
241: IS
242: l_uom pay_input_values_f.uom%TYPE;
243: CURSOR get_uom_cur
244: IS
245: SELECT piv.uom
246: FROM pay_element_types_f pet,

Line 248: pay_input_values_f piv,

244: IS
245: SELECT piv.uom
246: FROM pay_element_types_f pet,
247: per_all_assignments_f paaf,
248: pay_input_values_f piv,
249: per_pay_bases ppb,
250: per_pay_proposals ppp
251: WHERE ppp.pay_proposal_id = p_pay_proposal_id
252: and paaf.assignment_id = ppp.assignment_id

Line 549: ,PAY_INPUT_VALUES_F PIV

545: CURSOR Currency IS
546: SELECT HR_GENERAL.DECODE_LOOKUP('PAY_BASIS',PPB.PAY_BASIS)
547: ,PPB.PAY_ANNUALIZATION_FACTOR
548: FROM PAY_ELEMENT_TYPES_F PET
549: ,PAY_INPUT_VALUES_F PIV
550: ,PER_PAY_BASES PPB
551: WHERE PPB.PAY_BASIS_ID=L_PAY_BASIS_ID
552: AND PPB.INPUT_VALUE_ID=PIV.INPUT_VALUE_ID
553: AND p_effective_date BETWEEN

Line 652: ,pay_input_values_f piv

648: l_currency varchar2(100):=null ;
649: cursor csr_currency is
650: select pet.input_currency_code as currency_code
651: from per_pay_bases ppb
652: ,pay_input_values_f piv
653: ,pay_element_types_f pet
654: ,per_all_assignments_f paa
655: where paa.pay_basis_id = ppb.pay_basis_id
656: and ppb.input_value_id = piv.input_value_id

Line 845: pay_input_values_f piv,

841: IS
842: SELECT pet.input_currency_code
843: FROM pay_element_types_f pet,
844: per_all_assignments_f paaf,
845: pay_input_values_f piv,
846: per_pay_bases ppb
847: WHERE paaf.assignment_id = p_assignment_id
848: AND p_change_date BETWEEN paaf.effective_start_date
849: AND paaf.effective_end_date

Line 896: pay_input_values_f piv,

892: IS
893: SELECT pet.input_currency_code,piv.uom
894: FROM pay_element_types_f pet,
895: per_all_assignments_f paaf,
896: pay_input_values_f piv,
897: per_pay_bases ppb
898: WHERE paaf.assignment_id = p_assignment_id
899: AND p_change_date BETWEEN paaf.effective_start_date
900: AND paaf.effective_end_date

Line 1269: , PAY_INPUT_VALUES_F PIV

1265: , PPB.PAY_BASIS
1266: , PPB.PAY_ANNUALIZATION_FACTOR
1267: ,PIV.UOM
1268: FROM PAY_ELEMENT_TYPES_F PET
1269: , PAY_INPUT_VALUES_F PIV
1270: , PER_PAY_BASES PPB
1271: WHERE PPB.PAY_BASIS_ID=L_PAY_BASIS_ID
1272: AND PPB.INPUT_VALUE_ID=PIV.INPUT_VALUE_ID
1273: AND p_effective_date BETWEEN PIV.EFFECTIVE_START_DATE AND PIV.EFFECTIVE_END_DATE