DBA Data[Home] [Help]

APPS.PAY_GB_COURT_ORDER_UPGRADE dependencies on PAY_ASSIGNMENT_ACTIONS

Line 63: ,pay_assignment_actions aa

59: FROM pay_element_types_f et
60: ,pay_input_values_f iv
61: ,pay_run_results rr
62: ,per_assignments_f paf
63: ,pay_assignment_actions aa
64: ,pay_run_result_values prrv
65: WHERE paf.business_group_id = p_business_group_id
66: AND paf.assignment_id = aa.assignment_id
67: AND et.element_name IN ('Court Order','Court Order NTPP')

Line 254: pay_assignment_actions paa,

250: SELECT max(paa.assignment_action_id) assignment_action_id,
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,