DBA Data[Home] [Help]

APPS.PAY_FLOW_REQUESTS_PKG dependencies on PAY_PROCESS_FLOW_SETS

Line 69: from PAY_PROCESS_FLOW_SETS

65: -- Cursor for identifying the sets associated with a flow's individual processes
66: CURSOR csr_process_sets(p_process_flow_id pay_process_flows.process_flow_id%TYPE)
67: is
68: select set_id, process_flow_set_id
69: from PAY_PROCESS_FLOW_SETS
70: where process_flow_id = p_process_flow_id;
71: ---
72:
73: -- Cursor for identifying parameters in a set

Line 74: CURSOR csr_set_parameters(p_csr_set_id PAY_PROCESS_FLOW_SETS.set_id%TYPE)

70: where process_flow_id = p_process_flow_id;
71: ---
72:
73: -- Cursor for identifying parameters in a set
74: CURSOR csr_set_parameters(p_csr_set_id PAY_PROCESS_FLOW_SETS.set_id%TYPE)
75: is
76: select * from pay_para_set_variables
77: where set_id = p_csr_set_id;
78: ---

Line 286: from PAY_PROCESS_FLOW_SETS

282: -- Cursor for getting the set_if for the requests in a flow.
283:
284: CURSOR get_set_ids(p_process_flow_id pay_process_flows.process_flow_id%TYPE) is
285: select set_id
286: from PAY_PROCESS_FLOW_SETS
287: where process_flow_id = p_process_flow_id
288: order by process_flow_seq;
289:
290: -- Cursor for getting the variable values for a particular request.