APPS.PQP_GB_STAKEHOLDER_TEMPLATE dependencies on PAY_SHADOW_INPUT_VALUES

Line 75: FROM pay_shadow_input_values

71:
72: CURSOR csr_iv_emecntr(p_el_stkhldr_id NUMBER) IS
73: SELECT input_value_id
74: ,object_version_number
75: FROM pay_shadow_input_values
76: WHERE element_type_id = p_el_stkhldr_id
77: AND name = DECODE(p_frm_sd_contribution_method
78: ,'P','Percentage Contribution'
79: ,'F','Flat Rate Contribution'

Line 87: FROM pay_shadow_input_values

83:
84: CURSOR csr_iv_emrcntr(p_el_stkhldr_id NUMBER) IS
85: SELECT input_value_id
86: ,object_version_number
87: FROM pay_shadow_input_values
88: WHERE element_type_id = p_el_stkhldr_id
89: AND name = DECODE(p_frm_ae_type
90: ,'P','Employers Percentage'
91: ,'F','Employers Factor'

Line 100: FROM pay_shadow_input_values

96:
97: CURSOR csr_iv_schname(p_el_stkhldr_id NUMBER) IS
98: SELECT input_value_id
99: ,object_version_number
100: FROM pay_shadow_input_values
101: WHERE element_type_id = p_el_stkhldr_id
102: AND name = 'Scheme Name';
103:
104: row_iv_schname csr_iv_schname%ROWTYPE;