APPS.PQP_GB_PSI_FUNCTIONS dependencies on PAY_ELEMENT_TYPES_F

Line 5826: from pay_element_types_f

5822: -- cursor to find retro_element_type_id
5823: CURSOR csr_get_retro_ele_type_id
5824: IS
5825: select retro_summ_ele_id
5826: from pay_element_types_f
5827: where element_type_id = p_element_type_id
5828: and rownum=1;
5829:
5830:

Line 6169: from pay_element_types_f

6165: -- cursor to find retro_element_type_id
6166: CURSOR csr_get_retro_ele_type_id
6167: IS
6168: select retro_summ_ele_id
6169: from pay_element_types_f
6170: where element_type_id = p_element_type_id
6171: and rownum=1;
6172:
6173:

Line 7698: FROM pay_element_types_f

7694:
7695: CURSOR csr_get_ele_type_id
7696: IS
7697: SELECT element_type_id
7698: FROM pay_element_types_f
7699: WHERE element_name = p_element_name
7700: AND rownum=1;
7701:
7702: CURSOR csr_get_ele_attribution

Line 7724: FROM -- pay_element_types_f pet

7720: ,pei.eei_information16 column_name_source_type
7721: ,pei.eei_information17 column_name_source_name
7722: ,pei.eei_information18 row_name_source_type
7723: ,pei.eei_information19 row_name_source_name
7724: FROM -- pay_element_types_f pet
7725: pay_element_type_extra_info pei
7726: WHERE pei.element_type_id = p_element_type_id
7727: AND pei.information_type = 'PQP_UK_ELEMENT_ATTRIBUTION';
7728: BEGIN