APPS.PQP_GB_PSI_FUNCTIONS dependencies on PAY_ELEMENT_TYPE_EXTRA_INFO

Line 729: FROM pay_element_type_extra_info petei,

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

Line 753: FROM pay_element_type_extra_info petei,

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

Line 809: FROM pay_element_type_extra_info petei

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

Line 844: FROM pay_element_type_extra_info petei

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

Line 1123: ,column_name_source_type pay_element_type_extra_info.eei_information16%TYPE

1119: ,link_to_assign fnd_lookups.lookup_code%TYPE
1120: ,term_time_yes_no fnd_lookups.lookup_code%TYPE
1121: ,sum_multiple_entries_yn fnd_lookups.lookup_code%TYPE
1122: ,lookup_input_values_yn fnd_lookups.lookup_code%TYPE
1123: ,column_name_source_type pay_element_type_extra_info.eei_information16%TYPE
1124: ,column_name_source_name pay_element_type_extra_info.eei_information17%TYPE
1125: ,row_name_source_type pay_element_type_extra_info.eei_information18%TYPE
1126: ,row_name_source_name pay_element_type_extra_info.eei_information19%TYPE
1127: );

Line 1124: ,column_name_source_name pay_element_type_extra_info.eei_information17%TYPE

1120: ,term_time_yes_no fnd_lookups.lookup_code%TYPE
1121: ,sum_multiple_entries_yn fnd_lookups.lookup_code%TYPE
1122: ,lookup_input_values_yn fnd_lookups.lookup_code%TYPE
1123: ,column_name_source_type pay_element_type_extra_info.eei_information16%TYPE
1124: ,column_name_source_name pay_element_type_extra_info.eei_information17%TYPE
1125: ,row_name_source_type pay_element_type_extra_info.eei_information18%TYPE
1126: ,row_name_source_name pay_element_type_extra_info.eei_information19%TYPE
1127: );
1128:

Line 1125: ,row_name_source_type pay_element_type_extra_info.eei_information18%TYPE

1121: ,sum_multiple_entries_yn fnd_lookups.lookup_code%TYPE
1122: ,lookup_input_values_yn fnd_lookups.lookup_code%TYPE
1123: ,column_name_source_type pay_element_type_extra_info.eei_information16%TYPE
1124: ,column_name_source_name pay_element_type_extra_info.eei_information17%TYPE
1125: ,row_name_source_type pay_element_type_extra_info.eei_information18%TYPE
1126: ,row_name_source_name pay_element_type_extra_info.eei_information19%TYPE
1127: );
1128:
1129: TYPE t_ele_attribution IS TABLE OF r_ele_attribution

Line 1126: ,row_name_source_name pay_element_type_extra_info.eei_information19%TYPE

1122: ,lookup_input_values_yn fnd_lookups.lookup_code%TYPE
1123: ,column_name_source_type pay_element_type_extra_info.eei_information16%TYPE
1124: ,column_name_source_name pay_element_type_extra_info.eei_information17%TYPE
1125: ,row_name_source_type pay_element_type_extra_info.eei_information18%TYPE
1126: ,row_name_source_name pay_element_type_extra_info.eei_information19%TYPE
1127: );
1128:
1129: TYPE t_ele_attribution IS TABLE OF r_ele_attribution
1130: INDEX BY BINARY_INTEGER;