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 246: FROM pay_element_types_f pet,

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,
247: per_all_assignments_f paaf,
248: pay_input_values_f piv,
249: per_pay_bases ppb,
250: per_pay_proposals ppp

Line 548: FROM PAY_ELEMENT_TYPES_F PET

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

Line 653: ,pay_element_types_f pet

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

Line 838: l_currency pay_element_types_f.input_currency_code%TYPE;

834:
835: FUNCTION get_currency (p_assignment_id IN NUMBER, p_change_date IN DATE)
836: RETURN VARCHAR2
837: IS
838: l_currency pay_element_types_f.input_currency_code%TYPE;
839:
840: CURSOR currency
841: IS
842: SELECT pet.input_currency_code

Line 843: FROM pay_element_types_f pet,

839:
840: CURSOR currency
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

Line 887: l_currency pay_element_types_f.input_currency_code%TYPE;

883:
884: FUNCTION get_currency_format (p_assignment_id IN NUMBER, p_change_date IN DATE)
885: RETURN VARCHAR2
886: IS
887: l_currency pay_element_types_f.input_currency_code%TYPE;
888: l_uom varchar2(20);
889: l_five_curr pay_element_types_f.input_currency_code%TYPE;
890:
891: CURSOR currency

Line 889: l_five_curr pay_element_types_f.input_currency_code%TYPE;

885: RETURN VARCHAR2
886: IS
887: l_currency pay_element_types_f.input_currency_code%TYPE;
888: l_uom varchar2(20);
889: l_five_curr pay_element_types_f.input_currency_code%TYPE;
890:
891: CURSOR currency
892: IS
893: SELECT pet.input_currency_code,piv.uom

Line 894: FROM pay_element_types_f pet,

890:
891: CURSOR currency
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

Line 1268: FROM PAY_ELEMENT_TYPES_F PET

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