DBA Data[Home] [Help]

APPS.PAY_JP_GET_MONTH_BALANCE_PKG dependencies on PAY_BALANCE_FEEDS_F

Line 46: pay_balance_feeds_f FEED,

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
50: WHERE ASSACT.assignment_id = p_assignment_id

Line 110: pay_balance_feeds_f FEED,

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
114: WHERE ASSACT.assignment_id = p_assignment_id