APPS.PQP_GB_PSI_FUNCTIONS dependencies on PAY_ELEMENT_TYPES_F

Line 5936: from pay_element_types_f

5932: -- cursor to find retro_element_type_id
5933: CURSOR csr_get_retro_ele_type_id
5934: IS
5935: select retro_summ_ele_id
5936: from pay_element_types_f
5937: where element_type_id = p_element_type_id
5938: and rownum=1;
5939:
5940:

Line 6282: from pay_element_types_f

6278: -- cursor to find retro_element_type_id
6279: CURSOR csr_get_retro_ele_type_id
6280: IS
6281: select retro_summ_ele_id
6282: from pay_element_types_f
6283: where element_type_id = p_element_type_id
6284: and rownum=1;
6285:
6286:

Line 8163: FROM pay_element_types_f

8159:
8160: CURSOR csr_get_ele_type_id
8161: IS
8162: SELECT element_type_id
8163: FROM pay_element_types_f
8164: WHERE element_name = p_element_name
8165: AND rownum=1;
8166:
8167: CURSOR csr_get_ele_attribution

Line 8189: FROM -- pay_element_types_f pet

8185: ,pei.eei_information16 column_name_source_type
8186: ,pei.eei_information17 column_name_source_name
8187: ,pei.eei_information18 row_name_source_type
8188: ,pei.eei_information19 row_name_source_name
8189: FROM -- pay_element_types_f pet
8190: pay_element_type_extra_info pei
8191: WHERE pei.element_type_id = p_element_type_id
8192: AND pei.information_type = 'PQP_UK_ELEMENT_ATTRIBUTION';
8193: BEGIN