APPS.PQP_GB_PSI_FUNCTIONS dependencies on PAY_ELEMENT_TYPE_EXTRA_INFO

Line 722: FROM pay_element_type_extra_info petei,

718: eei_information5 industrial_flag,
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

Line 746: FROM pay_element_type_extra_info petei,

742: eei_information4 pension_flag,
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

Line 802: FROM pay_element_type_extra_info petei

798: ,petei.eei_information8
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

Line 837: FROM pay_element_type_extra_info petei

833: ,petei.eei_information8
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:

Line 1094: ,column_name_source_type pay_element_type_extra_info.eei_information16%TYPE

1090: ,link_to_assign fnd_lookups.lookup_code%TYPE
1091: ,term_time_yes_no fnd_lookups.lookup_code%TYPE
1092: ,sum_multiple_entries_yn fnd_lookups.lookup_code%TYPE
1093: ,lookup_input_values_yn fnd_lookups.lookup_code%TYPE
1094: ,column_name_source_type pay_element_type_extra_info.eei_information16%TYPE
1095: ,column_name_source_name pay_element_type_extra_info.eei_information17%TYPE
1096: ,row_name_source_type pay_element_type_extra_info.eei_information18%TYPE
1097: ,row_name_source_name pay_element_type_extra_info.eei_information19%TYPE
1098: );

Line 1095: ,column_name_source_name pay_element_type_extra_info.eei_information17%TYPE

1091: ,term_time_yes_no fnd_lookups.lookup_code%TYPE
1092: ,sum_multiple_entries_yn fnd_lookups.lookup_code%TYPE
1093: ,lookup_input_values_yn fnd_lookups.lookup_code%TYPE
1094: ,column_name_source_type pay_element_type_extra_info.eei_information16%TYPE
1095: ,column_name_source_name pay_element_type_extra_info.eei_information17%TYPE
1096: ,row_name_source_type pay_element_type_extra_info.eei_information18%TYPE
1097: ,row_name_source_name pay_element_type_extra_info.eei_information19%TYPE
1098: );
1099:

Line 1096: ,row_name_source_type pay_element_type_extra_info.eei_information18%TYPE

1092: ,sum_multiple_entries_yn fnd_lookups.lookup_code%TYPE
1093: ,lookup_input_values_yn fnd_lookups.lookup_code%TYPE
1094: ,column_name_source_type pay_element_type_extra_info.eei_information16%TYPE
1095: ,column_name_source_name pay_element_type_extra_info.eei_information17%TYPE
1096: ,row_name_source_type pay_element_type_extra_info.eei_information18%TYPE
1097: ,row_name_source_name pay_element_type_extra_info.eei_information19%TYPE
1098: );
1099:
1100: TYPE t_ele_attribution IS TABLE OF r_ele_attribution

Line 1097: ,row_name_source_name pay_element_type_extra_info.eei_information19%TYPE

1093: ,lookup_input_values_yn fnd_lookups.lookup_code%TYPE
1094: ,column_name_source_type pay_element_type_extra_info.eei_information16%TYPE
1095: ,column_name_source_name pay_element_type_extra_info.eei_information17%TYPE
1096: ,row_name_source_type pay_element_type_extra_info.eei_information18%TYPE
1097: ,row_name_source_name pay_element_type_extra_info.eei_information19%TYPE
1098: );
1099:
1100: TYPE t_ele_attribution IS TABLE OF r_ele_attribution
1101: INDEX BY BINARY_INTEGER;