APPS.PAY_GB_COURT_ORDER_UPGRADE dependencies on PAY_ACTION_CONTEXTS

Line 77: FROM pay_action_contexts pac

73: AND aa.assignment_action_id = rr.assignment_action_id
74: AND prrv.run_result_id = rr.run_result_id
75: AND prrv.input_value_id = iv.input_value_id
76: AND NOT EXISTS (SELECT NULL
77: FROM pay_action_contexts pac
78: WHERE pac.assignment_id = aa.assignment_id
79: AND pac.assignment_action_id = aa.assignment_action_id
80: AND pac.context_id = l_context_id
81: AND pac.context_value = nvl(prrv.result_value, 'Unknown'));

Line 135: INSERT INTO pay_action_contexts

131: END IF;
132: --
133: -- Create missing action contexts.
134: --
135: INSERT INTO pay_action_contexts
136: (assignment_action_id
137: ,assignment_id
138: ,context_id
139: ,context_value)

Line 148: FROM pay_action_contexts pac

144: ,l_context_id
145: ,l_result_rec.result_value
146: from dual
147: where NOT EXISTS (SELECT NULL
148: FROM pay_action_contexts pac
149: WHERE pac.assignment_id = l_result_rec.assignment_id
150: AND pac.assignment_action_id = l_result_rec.assignment_action_id
151: AND pac.context_id = l_context_id
152: AND pac.context_value = nvl(l_result_rec.result_value, 'Unknown')));

Line 255: pay_action_contexts pac,

251: pac.context_value context_value,
252: nvl(pay_balance_pkg.get_value(p_defined_balance_id, max(pac.assignment_action_id), null,null, fc.context_id, pac.context_value,null,null),0) paid_value
253: FROM per_assignments_f paf,
254: pay_assignment_actions paa,
255: pay_action_contexts pac,
256: ff_contexts fc,
257: pay_element_types_f pet,
258: pay_input_values_f piv,
259: pay_run_results prr,