DBA Data[Home] [Help]

APPS.PSP_ENC_ASSIGNMENT_CHANGES dependencies on PSP_ENC_ELEMENTS

Line 30: FROM psp_enc_elements pee

26: SELECT pel.element_type_id
27: FROM pay_element_links_f pel
28: WHERE pel.element_link_id = p_element_link_id
29: AND EXISTS (SELECT pee.element_type_id
30: FROM psp_enc_elements pee
31: WHERE pee.element_type_id = pel.element_type_id
32: AND pee.business_group_id = bg_id)
33: AND ROWNUM = 1;
34:

Line 111: FROM psp_enc_elements pee

107: SELECT pel.element_type_id
108: FROM pay_element_links_f pel
109: WHERE pel.element_link_id = p_element_link_id_o
110: AND EXISTS (SELECT pee.element_type_id
111: FROM psp_enc_elements pee
112: WHERE pee.element_type_id = pel.element_type_id
113: AND pee.business_group_id = bg_id )
114: AND ROWNUM = 1;
115:

Line 187: FROM psp_enc_elements pee

183: SELECT pel.element_type_id
184: FROM pay_element_links_f pel
185: WHERE pel.element_link_id = p_element_link_id_o
186: AND EXISTS (SELECT pee.element_type_id
187: FROM psp_enc_elements pee
188: WHERE pee.element_type_id = pel.element_type_id
189: AND pee.business_group_id = bg_id )
190: AND ROWNUM = 1;
191: