APPS.PQP_UK_UNION_TEMPLATE dependencies on PAY_SHADOW_INPUT_VALUES

Line 57: c_iv_payvlu_nm CONSTANT pay_shadow_input_values.name%TYPE:=

53: p_frm_business_grp_id (N) - Business Group ID
54: ----------------------------------------------------------------------*/
55: l_proc VARCHAR2(61) := g_proc||'create_user_template';
56:
57: c_iv_payvlu_nm CONSTANT pay_shadow_input_values.name%TYPE:=
58: 'Pay Value';
59: c_iv_fdsltd_nm CONSTANT pay_shadow_input_values.name%TYPE:=
60: 'Fund Selected';
61: l_te_usrstr_id pay_element_templates.template_id%TYPE;

Line 59: c_iv_fdsltd_nm CONSTANT pay_shadow_input_values.name%TYPE:=

55: l_proc VARCHAR2(61) := g_proc||'create_user_template';
56:
57: c_iv_payvlu_nm CONSTANT pay_shadow_input_values.name%TYPE:=
58: 'Pay Value';
59: c_iv_fdsltd_nm CONSTANT pay_shadow_input_values.name%TYPE:=
60: 'Fund Selected';
61: l_te_usrstr_id pay_element_templates.template_id%TYPE;
62: l_te_source_id pay_element_templates.template_id%TYPE;
63:

Line 132: FROM pay_shadow_input_values siv

128: CURSOR csr_iv_payvlu(p_el_unnddn_id NUMBER
129: ,p_iv_payvlu_nm VARCHAR2) IS
130: SELECT siv.input_value_id
131: ,siv.object_version_number
132: FROM pay_shadow_input_values siv
133: WHERE siv.element_type_id = p_el_unnddn_id
134: AND siv.name = p_iv_payvlu_nm;
135:
136: