DBA Data[Home] [Help]

APPS.PAY_JP_GET_MONTH_BALANCE_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 48: pay_payroll_actions PACT,

44: FROM
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

Line 112: pay_payroll_actions PACT,

108: INTO l_balance
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')