APPS.PER_SALADMIN_UTILITY dependencies on PAY_ELEMENT_TYPES_F

Line 63: ,pay_element_types_f pet

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
67: and piv.element_type_id = pet.element_type_id

Line 121: ,pay_element_types_f pet

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
125: and piv.element_type_id = pet.element_type_id

Line 242: FROM pay_element_types_f pet,

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,
243: per_all_assignments_f paaf,
244: pay_input_values_f piv,
245: per_pay_bases ppb,
246: per_pay_proposals ppp

Line 517: FROM PAY_ELEMENT_TYPES_F PET

513:
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

Line 622: ,pay_element_types_f pet

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
626: and piv.element_type_id = pet.element_type_id

Line 807: l_currency pay_element_types_f.input_currency_code%TYPE;

803:
804: FUNCTION get_currency (p_assignment_id IN NUMBER, p_change_date IN DATE)
805: RETURN VARCHAR2
806: IS
807: l_currency pay_element_types_f.input_currency_code%TYPE;
808:
809: CURSOR currency
810: IS
811: SELECT pet.input_currency_code

Line 812: FROM pay_element_types_f pet,

808:
809: CURSOR currency
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

Line 856: l_currency pay_element_types_f.input_currency_code%TYPE;

852:
853: FUNCTION get_currency_format (p_assignment_id IN NUMBER, p_change_date IN DATE)
854: RETURN VARCHAR2
855: IS
856: l_currency pay_element_types_f.input_currency_code%TYPE;
857: l_uom varchar2(20);
858: l_five_curr pay_element_types_f.input_currency_code%TYPE;
859:
860: CURSOR currency

Line 858: l_five_curr pay_element_types_f.input_currency_code%TYPE;

854: RETURN VARCHAR2
855: IS
856: l_currency pay_element_types_f.input_currency_code%TYPE;
857: l_uom varchar2(20);
858: l_five_curr pay_element_types_f.input_currency_code%TYPE;
859:
860: CURSOR currency
861: IS
862: SELECT pet.input_currency_code,piv.uom

Line 863: FROM pay_element_types_f pet,

859:
860: CURSOR currency
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

Line 1043: FROM PAY_ELEMENT_TYPES_F PET

1039: SELECT PET.INPUT_CURRENCY_CODE
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