APPS.PQP_GB_PSI_FUNCTIONS dependencies on PAY_ELEMENT_TYPES_F

Line 730: pay_element_types_f petf

726: eei_information6 spread_bonus_flag,
727: eei_information7 basic_pay_reckonable,
728: eei_information8 pre_75_reckonable
729: FROM pay_element_type_extra_info petei,
730: pay_element_types_f petf
731: WHERE information_type = 'PQP_GB_PENSERV_ALLOWANCE_INFO'
732: AND petei.element_type_id = petf.element_type_id
733: AND petei.eei_information2 IS NOT NULL
734: AND ((p_from_date BETWEEN petf.effective_start_date AND petf.effective_end_date)

Line 754: pay_element_types_f petf

750: eei_information5 industrial_flag,
751: eei_information6 basic_pay_reckonable,
752: eei_information7 pre_75_reckonable
753: FROM pay_element_type_extra_info petei,
754: pay_element_types_f petf
755: WHERE information_type = 'PQP_GB_PENSERV_BONUS_INFO'
756: AND petei.element_type_id = petf.element_type_id
757: AND petei.eei_information2 IS NOT NULL
758: AND ((p_from_date BETWEEN petf.effective_start_date AND petf.effective_end_date)

Line 810: ,pay_element_types_f pet

806: ,petei.eei_information9
807: ,petei.eei_information10
808: ,pet.retro_summ_ele_id -- retro element type ID -- 115.33 (1)
809: FROM pay_element_type_extra_info petei
810: ,pay_element_types_f pet
811: ,pay_input_values_f piv
812: ,pay_input_values_f piv2
813: WHERE petei.information_type = c_information_type
814: AND pet.element_type_id = petei.element_type_id

Line 845: ,pay_element_types_f pet

841: ,petei.eei_information9
842: ,petei.eei_information10
843: ,pet.retro_summ_ele_id -- retro element type ID -- 115.33 (1)
844: FROM pay_element_type_extra_info petei
845: ,pay_element_types_f pet
846: WHERE petei.information_type = c_information_type
847: AND pet.element_type_id = petei.element_type_id;
848:
849:

Line 1113: ,qualifier pay_element_types_f.element_name%TYPE

1109: TYPE r_ele_attribution IS RECORD
1110: (
1111: from_time_dimension fnd_lookups.lookup_code%TYPE
1112: ,pay_source_value fnd_lookups.lookup_code%TYPE
1113: ,qualifier pay_element_types_f.element_name%TYPE
1114: ,fte fnd_lookups.lookup_code%TYPE
1115: ,termtime fnd_lookups.lookup_code%TYPE
1116: ,calc_type fnd_lookups.lookup_code%TYPE
1117: ,calc_value fnd_lookups.lookup_code%TYPE