72: where ppr_inner.fnd_request_id = p_fnd_request_id
73: )
74: order by process_req_seq_id;
75:
76: -- Cursor to get the set_id from pay_process_flow_sets
77: cursor csr_set_id(p_process_flow_seq pay_process_flow_sets.process_flow_seq%TYPE,
78: p_process_flow_id pay_process_flows.process_flow_id%TYPE) is
79: select pfs.set_id
80: from pay_process_flow_sets pfs
73: )
74: order by process_req_seq_id;
75:
76: -- Cursor to get the set_id from pay_process_flow_sets
77: cursor csr_set_id(p_process_flow_seq pay_process_flow_sets.process_flow_seq%TYPE,
78: p_process_flow_id pay_process_flows.process_flow_id%TYPE) is
79: select pfs.set_id
80: from pay_process_flow_sets pfs
81: where pfs.process_flow_id = p_process_flow_id
76: -- Cursor to get the set_id from pay_process_flow_sets
77: cursor csr_set_id(p_process_flow_seq pay_process_flow_sets.process_flow_seq%TYPE,
78: p_process_flow_id pay_process_flows.process_flow_id%TYPE) is
79: select pfs.set_id
80: from pay_process_flow_sets pfs
81: where pfs.process_flow_id = p_process_flow_id
82: and pfs.process_flow_seq = p_process_flow_seq;
83:
84: --
108: close csr_flow_set_id;
109:
110: else
111: -- Get the process set name using the process_flow_id and process_req_seq
112: -- from pay_process_flow_sets
113: open csr_set_id(process_flow_rec.rownum-1,
114: process_flow_rec.process_flow_id);
115: fetch csr_set_id into l_set_id;
116: close csr_set_id;