DBA Data[Home] [Help]

APPS.PAY_JP_GET_MONTH_BALANCE_PKG dependencies on PAY_RUN_RESULT_VALUES

Line 45: pay_run_result_values TARGET,

41: BEGIN
42: SELECT NVL(SUM(TARGET.result_value * FEED.scale),0)
43: INTO l_balance
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

Line 109: FROM pay_run_result_values TARGET,

105:
106: BEGIN
107: SELECT NVL(SUM(TARGET.result_value * FEED.scale),0)
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