APPS.PAY_VOID_UI_PKG dependencies on PAY_PARAMETER_SETS

Line 47: l_set_id pay_parameter_sets.set_id%TYPE;

43: -- ----------------------------------------------------------------------------
44: function get_process_name(p_fnd_request_id in number)
45: return varchar2
46: IS
47: l_set_id pay_parameter_sets.set_id%TYPE;
48: l_process_flow_id pay_process_flows.process_flow_id%TYPE;
49: l_set_name pay_parameter_definitions_tl.name%TYPE;
50:
51: --

Line 53: cursor csr_set_name(p_set_id pay_parameter_sets.set_id%TYPE) is

49: l_set_name pay_parameter_definitions_tl.name%TYPE;
50:
51: --
52: -- Cursor to get the process name based on the process set_id
53: cursor csr_set_name(p_set_id pay_parameter_sets.set_id%TYPE) is
54: select ppdt.name
55: from pay_parameter_definitions_tl ppdt,
56: pay_parameters pp,
57: pay_parameter_sets pps

Line 57: pay_parameter_sets pps

53: cursor csr_set_name(p_set_id pay_parameter_sets.set_id%TYPE) is
54: select ppdt.name
55: from pay_parameter_definitions_tl ppdt,
56: pay_parameters pp,
57: pay_parameter_sets pps
58: where pps.set_id = p_set_id
59: and pps.set_name_id = pp.parameter_def_id
60: and pp.parameter_def_id = ppdt.parameter_def_id;
61: --