DBA Data[Home] [Help]

APPS.PQP_GB_STAKEHOLDER_TEMPLATE dependencies on PAY_SHADOW_ELEMENT_TYPES

Line 66: FROM pay_shadow_element_types

62:
63: CURSOR csr_el_stkhldr_details(p_el_stkhldr_nm VARCHAR2) IS
64: SELECT element_type_id
65: ,object_version_number
66: FROM pay_shadow_element_types
67: WHERE template_id = l_te_ustrctr_id
68: AND element_name = p_el_stkhldr_nm;
69:
70: row_el_stkhldr_details csr_el_stkhldr_details%ROWTYPE;

Line 113: FROM pay_shadow_element_types psbt,

109: -- cursor to fetch the core element id
110: --
111: CURSOR c5 (c_element_name in varchar2) is
112: SELECT ptco.core_object_id
113: FROM pay_shadow_element_types psbt,
114: pay_template_core_objects ptco
115: WHERE psbt.template_id = l_te_ustrctr_id
116: AND psbt.element_name = c_element_name
117: AND ptco.template_id = psbt.template_id