138: l_temp varchar2(1000);
139:
140: -- Variable to collect the default standard link flag,Qualifying conditions
141: -- and multiply value flag from the element type
142: l_standard_link_flag pay_element_links_f.standard_link_flag%type;
143: l_qualifying_age pay_element_links_f.qualifying_age%type;
144: l_qualifying_length_of_service
145: pay_element_links_f.qualifying_length_of_service%type;
146: l_qualifying_units pay_element_links_f.qualifying_units%type;
139:
140: -- Variable to collect the default standard link flag,Qualifying conditions
141: -- and multiply value flag from the element type
142: l_standard_link_flag pay_element_links_f.standard_link_flag%type;
143: l_qualifying_age pay_element_links_f.qualifying_age%type;
144: l_qualifying_length_of_service
145: pay_element_links_f.qualifying_length_of_service%type;
146: l_qualifying_units pay_element_links_f.qualifying_units%type;
147: l_multiply_value_flag pay_element_links_f.multiply_value_flag%type;
141: -- and multiply value flag from the element type
142: l_standard_link_flag pay_element_links_f.standard_link_flag%type;
143: l_qualifying_age pay_element_links_f.qualifying_age%type;
144: l_qualifying_length_of_service
145: pay_element_links_f.qualifying_length_of_service%type;
146: l_qualifying_units pay_element_links_f.qualifying_units%type;
147: l_multiply_value_flag pay_element_links_f.multiply_value_flag%type;
148:
149: -- Cursor to get the structure number to be passed to get the cost/balance id
142: l_standard_link_flag pay_element_links_f.standard_link_flag%type;
143: l_qualifying_age pay_element_links_f.qualifying_age%type;
144: l_qualifying_length_of_service
145: pay_element_links_f.qualifying_length_of_service%type;
146: l_qualifying_units pay_element_links_f.qualifying_units%type;
147: l_multiply_value_flag pay_element_links_f.multiply_value_flag%type;
148:
149: -- Cursor to get the structure number to be passed to get the cost/balance id
150: cursor csr_flexnum is
143: l_qualifying_age pay_element_links_f.qualifying_age%type;
144: l_qualifying_length_of_service
145: pay_element_links_f.qualifying_length_of_service%type;
146: l_qualifying_units pay_element_links_f.qualifying_units%type;
147: l_multiply_value_flag pay_element_links_f.multiply_value_flag%type;
148:
149: -- Cursor to get the structure number to be passed to get the cost/balance id
150: cursor csr_flexnum is
151: select cost_allocation_structure