APPS.PQP_GB_PSI_FUNCTIONS dependencies on PAY_ELEMENT_TYPES_F

Line 723: pay_element_types_f petf

719: eei_information6 spread_bonus_flag,
720: eei_information7 basic_pay_reckonable,
721: eei_information8 pre_75_reckonable
722: FROM pay_element_type_extra_info petei,
723: pay_element_types_f petf
724: WHERE information_type = 'PQP_GB_PENSERV_ALLOWANCE_INFO'
725: AND petei.element_type_id = petf.element_type_id
726: AND petei.eei_information2 IS NOT NULL
727: AND ((p_from_date BETWEEN petf.effective_start_date AND petf.effective_end_date)

Line 747: pay_element_types_f petf

743: eei_information5 industrial_flag,
744: eei_information6 basic_pay_reckonable,
745: eei_information7 pre_75_reckonable
746: FROM pay_element_type_extra_info petei,
747: pay_element_types_f petf
748: WHERE information_type = 'PQP_GB_PENSERV_BONUS_INFO'
749: AND petei.element_type_id = petf.element_type_id
750: AND petei.eei_information2 IS NOT NULL
751: AND ((p_from_date BETWEEN petf.effective_start_date AND petf.effective_end_date)

Line 803: ,pay_element_types_f pet

799: ,petei.eei_information9
800: ,petei.eei_information10
801: ,pet.retro_summ_ele_id -- retro element type ID -- 115.33 (1)
802: FROM pay_element_type_extra_info petei
803: ,pay_element_types_f pet
804: ,pay_input_values_f piv
805: ,pay_input_values_f piv2
806: WHERE petei.information_type = c_information_type
807: AND pet.element_type_id = petei.element_type_id

Line 838: ,pay_element_types_f pet

834: ,petei.eei_information9
835: ,petei.eei_information10
836: ,pet.retro_summ_ele_id -- retro element type ID -- 115.33 (1)
837: FROM pay_element_type_extra_info petei
838: ,pay_element_types_f pet
839: WHERE petei.information_type = c_information_type
840: AND pet.element_type_id = petei.element_type_id;
841:
842:

Line 1084: ,qualifier pay_element_types_f.element_name%TYPE

1080: TYPE r_ele_attribution IS RECORD
1081: (
1082: from_time_dimension fnd_lookups.lookup_code%TYPE
1083: ,pay_source_value fnd_lookups.lookup_code%TYPE
1084: ,qualifier pay_element_types_f.element_name%TYPE
1085: ,fte fnd_lookups.lookup_code%TYPE
1086: ,termtime fnd_lookups.lookup_code%TYPE
1087: ,calc_type fnd_lookups.lookup_code%TYPE
1088: ,calc_value fnd_lookups.lookup_code%TYPE