DBA Data[Home] [Help]

APPS.PAY_JP_GET_MONTH_BALANCE_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 49: pay_assignment_actions ASSACT

45: pay_run_result_values TARGET,
46: pay_balance_feeds_f FEED,
47: pay_run_results RR,
48: pay_payroll_actions PACT,
49: pay_assignment_actions ASSACT
50: WHERE ASSACT.assignment_id = p_assignment_id
51: AND ASSACT.payroll_action_id = PACT.payroll_action_id
52: AND PACT.effective_date
53: between l_start_month_date and l_end_month_date

Line 113: pay_assignment_actions ASSACT

109: FROM pay_run_result_values TARGET,
110: pay_balance_feeds_f FEED,
111: pay_run_results RR,
112: pay_payroll_actions PACT,
113: pay_assignment_actions ASSACT
114: WHERE ASSACT.assignment_id = p_assignment_id
115: AND ASSACT.payroll_action_id = PACT.payroll_action_id
116: AND PACT.action_type IN ('B','V')
117: AND PACT.effective_date