DBA Data[Home] [Help]

APPS.PQP_GB_PENSIONS_TEMPLATE dependencies on PAY_ELEMENT_TYPE_EXTRA_INFO

Line 94: l_eei_information2 pay_element_type_extra_info.eei_information2%TYPE;

90: l_name pay_input_values_f.name%TYPE;
91: i NUMBER;
92:
93: -- Extra Information variables
94: l_eei_information2 pay_element_type_extra_info.eei_information2%TYPE;
95: l_eei_information3 pay_element_type_extra_info.eei_information3%TYPE;
96: l_eei_information4 pay_element_type_extra_info.eei_information4%TYPE;
97: l_eei_information5 pay_element_type_extra_info.eei_information5%TYPE;
98: l_eei_information6 pay_element_type_extra_info.eei_information6%TYPE;

Line 95: l_eei_information3 pay_element_type_extra_info.eei_information3%TYPE;

91: i NUMBER;
92:
93: -- Extra Information variables
94: l_eei_information2 pay_element_type_extra_info.eei_information2%TYPE;
95: l_eei_information3 pay_element_type_extra_info.eei_information3%TYPE;
96: l_eei_information4 pay_element_type_extra_info.eei_information4%TYPE;
97: l_eei_information5 pay_element_type_extra_info.eei_information5%TYPE;
98: l_eei_information6 pay_element_type_extra_info.eei_information6%TYPE;
99: l_eei_information7 pay_element_type_extra_info.eei_information7%TYPE;

Line 96: l_eei_information4 pay_element_type_extra_info.eei_information4%TYPE;

92:
93: -- Extra Information variables
94: l_eei_information2 pay_element_type_extra_info.eei_information2%TYPE;
95: l_eei_information3 pay_element_type_extra_info.eei_information3%TYPE;
96: l_eei_information4 pay_element_type_extra_info.eei_information4%TYPE;
97: l_eei_information5 pay_element_type_extra_info.eei_information5%TYPE;
98: l_eei_information6 pay_element_type_extra_info.eei_information6%TYPE;
99: l_eei_information7 pay_element_type_extra_info.eei_information7%TYPE;
100: l_eei_information8 pay_element_type_extra_info.eei_information8%TYPE;

Line 97: l_eei_information5 pay_element_type_extra_info.eei_information5%TYPE;

93: -- Extra Information variables
94: l_eei_information2 pay_element_type_extra_info.eei_information2%TYPE;
95: l_eei_information3 pay_element_type_extra_info.eei_information3%TYPE;
96: l_eei_information4 pay_element_type_extra_info.eei_information4%TYPE;
97: l_eei_information5 pay_element_type_extra_info.eei_information5%TYPE;
98: l_eei_information6 pay_element_type_extra_info.eei_information6%TYPE;
99: l_eei_information7 pay_element_type_extra_info.eei_information7%TYPE;
100: l_eei_information8 pay_element_type_extra_info.eei_information8%TYPE;
101: l_eei_information9 pay_element_type_extra_info.eei_information9%TYPE;

Line 98: l_eei_information6 pay_element_type_extra_info.eei_information6%TYPE;

94: l_eei_information2 pay_element_type_extra_info.eei_information2%TYPE;
95: l_eei_information3 pay_element_type_extra_info.eei_information3%TYPE;
96: l_eei_information4 pay_element_type_extra_info.eei_information4%TYPE;
97: l_eei_information5 pay_element_type_extra_info.eei_information5%TYPE;
98: l_eei_information6 pay_element_type_extra_info.eei_information6%TYPE;
99: l_eei_information7 pay_element_type_extra_info.eei_information7%TYPE;
100: l_eei_information8 pay_element_type_extra_info.eei_information8%TYPE;
101: l_eei_information9 pay_element_type_extra_info.eei_information9%TYPE;
102: l_eei_information10 pay_element_type_extra_info.eei_information10%TYPE;

Line 99: l_eei_information7 pay_element_type_extra_info.eei_information7%TYPE;

95: l_eei_information3 pay_element_type_extra_info.eei_information3%TYPE;
96: l_eei_information4 pay_element_type_extra_info.eei_information4%TYPE;
97: l_eei_information5 pay_element_type_extra_info.eei_information5%TYPE;
98: l_eei_information6 pay_element_type_extra_info.eei_information6%TYPE;
99: l_eei_information7 pay_element_type_extra_info.eei_information7%TYPE;
100: l_eei_information8 pay_element_type_extra_info.eei_information8%TYPE;
101: l_eei_information9 pay_element_type_extra_info.eei_information9%TYPE;
102: l_eei_information10 pay_element_type_extra_info.eei_information10%TYPE;
103: l_eei_information11 pay_element_type_extra_info.eei_information11%TYPE;

Line 100: l_eei_information8 pay_element_type_extra_info.eei_information8%TYPE;

96: l_eei_information4 pay_element_type_extra_info.eei_information4%TYPE;
97: l_eei_information5 pay_element_type_extra_info.eei_information5%TYPE;
98: l_eei_information6 pay_element_type_extra_info.eei_information6%TYPE;
99: l_eei_information7 pay_element_type_extra_info.eei_information7%TYPE;
100: l_eei_information8 pay_element_type_extra_info.eei_information8%TYPE;
101: l_eei_information9 pay_element_type_extra_info.eei_information9%TYPE;
102: l_eei_information10 pay_element_type_extra_info.eei_information10%TYPE;
103: l_eei_information11 pay_element_type_extra_info.eei_information11%TYPE;
104: l_eei_information12 pay_element_type_extra_info.eei_information12%TYPE;

Line 101: l_eei_information9 pay_element_type_extra_info.eei_information9%TYPE;

97: l_eei_information5 pay_element_type_extra_info.eei_information5%TYPE;
98: l_eei_information6 pay_element_type_extra_info.eei_information6%TYPE;
99: l_eei_information7 pay_element_type_extra_info.eei_information7%TYPE;
100: l_eei_information8 pay_element_type_extra_info.eei_information8%TYPE;
101: l_eei_information9 pay_element_type_extra_info.eei_information9%TYPE;
102: l_eei_information10 pay_element_type_extra_info.eei_information10%TYPE;
103: l_eei_information11 pay_element_type_extra_info.eei_information11%TYPE;
104: l_eei_information12 pay_element_type_extra_info.eei_information12%TYPE;
105: --

Line 102: l_eei_information10 pay_element_type_extra_info.eei_information10%TYPE;

98: l_eei_information6 pay_element_type_extra_info.eei_information6%TYPE;
99: l_eei_information7 pay_element_type_extra_info.eei_information7%TYPE;
100: l_eei_information8 pay_element_type_extra_info.eei_information8%TYPE;
101: l_eei_information9 pay_element_type_extra_info.eei_information9%TYPE;
102: l_eei_information10 pay_element_type_extra_info.eei_information10%TYPE;
103: l_eei_information11 pay_element_type_extra_info.eei_information11%TYPE;
104: l_eei_information12 pay_element_type_extra_info.eei_information12%TYPE;
105: --
106: TYPE t_avc_prov IS TABLE OF VARCHAR2(80)

Line 103: l_eei_information11 pay_element_type_extra_info.eei_information11%TYPE;

99: l_eei_information7 pay_element_type_extra_info.eei_information7%TYPE;
100: l_eei_information8 pay_element_type_extra_info.eei_information8%TYPE;
101: l_eei_information9 pay_element_type_extra_info.eei_information9%TYPE;
102: l_eei_information10 pay_element_type_extra_info.eei_information10%TYPE;
103: l_eei_information11 pay_element_type_extra_info.eei_information11%TYPE;
104: l_eei_information12 pay_element_type_extra_info.eei_information12%TYPE;
105: --
106: TYPE t_avc_prov IS TABLE OF VARCHAR2(80)
107: INDEX BY BINARY_INTEGER;

Line 104: l_eei_information12 pay_element_type_extra_info.eei_information12%TYPE;

100: l_eei_information8 pay_element_type_extra_info.eei_information8%TYPE;
101: l_eei_information9 pay_element_type_extra_info.eei_information9%TYPE;
102: l_eei_information10 pay_element_type_extra_info.eei_information10%TYPE;
103: l_eei_information11 pay_element_type_extra_info.eei_information11%TYPE;
104: l_eei_information12 pay_element_type_extra_info.eei_information12%TYPE;
105: --
106: TYPE t_avc_prov IS TABLE OF VARCHAR2(80)
107: INDEX BY BINARY_INTEGER;
108:

Line 718: FROM pay_element_type_extra_info petei

714: l_ovn_eei number;
715: --
716: CURSOR eei is
717: SELECT element_type_extra_info_id
718: FROM pay_element_type_extra_info petei
719: WHERE element_type_id=p_ele_type_id ;
720:
721:
722: CURSOR c1 is