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 238: l_uom pay_input_values_f.uom%TYPE;

234:
235: FUNCTION get_uom(p_pay_proposal_id IN NUMBER)
236: RETURN VARCHAR2
237: IS
238: l_uom pay_input_values_f.uom%TYPE;
239: CURSOR get_uom_cur
240: IS
241: SELECT piv.uom
242: FROM pay_element_types_f pet,

Line 244: pay_input_values_f piv,

240: IS
241: SELECT piv.uom
242: FROM pay_element_types_f pet,
243: per_all_assignments_f paaf,
244: pay_input_values_f piv,
245: per_pay_bases ppb,
246: per_pay_proposals ppp
247: WHERE ppp.pay_proposal_id = p_pay_proposal_id
248: and paaf.assignment_id = ppp.assignment_id

Line 518: ,PAY_INPUT_VALUES_F PIV

514: CURSOR Currency IS
515: SELECT HR_GENERAL.DECODE_LOOKUP('PAY_BASIS',PPB.PAY_BASIS)
516: ,PPB.PAY_ANNUALIZATION_FACTOR
517: FROM PAY_ELEMENT_TYPES_F PET
518: ,PAY_INPUT_VALUES_F PIV
519: ,PER_PAY_BASES PPB
520: WHERE PPB.PAY_BASIS_ID=L_PAY_BASIS_ID
521: AND PPB.INPUT_VALUE_ID=PIV.INPUT_VALUE_ID
522: AND p_effective_date BETWEEN

Line 621: ,pay_input_values_f piv

617: l_currency varchar2(100):=null ;
618: cursor csr_currency is
619: select pet.input_currency_code as currency_code
620: from per_pay_bases ppb
621: ,pay_input_values_f piv
622: ,pay_element_types_f pet
623: ,per_all_assignments_f paa
624: where paa.pay_basis_id = ppb.pay_basis_id
625: and ppb.input_value_id = piv.input_value_id

Line 814: pay_input_values_f piv,

810: IS
811: SELECT pet.input_currency_code
812: FROM pay_element_types_f pet,
813: per_all_assignments_f paaf,
814: pay_input_values_f piv,
815: per_pay_bases ppb
816: WHERE paaf.assignment_id = p_assignment_id
817: AND p_change_date BETWEEN paaf.effective_start_date
818: AND paaf.effective_end_date

Line 865: pay_input_values_f piv,

861: IS
862: SELECT pet.input_currency_code,piv.uom
863: FROM pay_element_types_f pet,
864: per_all_assignments_f paaf,
865: pay_input_values_f piv,
866: per_pay_bases ppb
867: WHERE paaf.assignment_id = p_assignment_id
868: AND p_change_date BETWEEN paaf.effective_start_date
869: AND paaf.effective_end_date

Line 1044: , PAY_INPUT_VALUES_F PIV

1040: , PPB.PAY_BASIS
1041: , PPB.PAY_ANNUALIZATION_FACTOR
1042: ,PIV.UOM
1043: FROM PAY_ELEMENT_TYPES_F PET
1044: , PAY_INPUT_VALUES_F PIV
1045: , PER_PAY_BASES PPB
1046: WHERE PPB.PAY_BASIS_ID=L_PAY_BASIS_ID
1047: AND PPB.INPUT_VALUE_ID=PIV.INPUT_VALUE_ID
1048: AND p_effective_date BETWEEN PIV.EFFECTIVE_START_DATE AND PIV.EFFECTIVE_END_DATE