APPS.PY_ZA_BAL dependencies on PAY_ASSIGNMENT_LATEST_BALANCES

Line 57: from pay_assignment_latest_balances

53: cursor c2 (c_assignment_id IN NUMBER,
54: c_defined_bal_id IN NUMBER) is
55: select value,
56: assignment_action_id
57: from pay_assignment_latest_balances
58: where assignment_id = c_assignment_id
59: and defined_balance_id = c_defined_bal_id;
60: --
61: BEGIN

Line 122: from pay_assignment_latest_balances

118: --
119: cursor c1 (c_asg_action_id IN NUMBER,
120: c_defined_balance_id IN NUMBER) is
121: SELECT value
122: from pay_assignment_latest_balances
123: Where assignment_action_id = c_asg_action_id
124: and defined_balance_id = c_defined_balance_id;
125: --
126: BEGIN

Line 240: -- from the pay_assignment_latest_balances table.

236: --
237: --------------------------------------------------------------------------------
238: --
239: -- This function checks to see whether an expired_value can be used
240: -- from the pay_assignment_latest_balances table.
241: --
242: FUNCTION check_expired_action(
243: p_defined_balance_id IN NUMBER,
244: p_assignment_id IN NUMBER,

Line 254: FROM pay_assignment_latest_balances

250: cursor expired_val (c_defined_balance_id IN NUMBER,
251: c_assignment_action_id IN NUMBER,
252: c_assignment_id IN NUMBER) is
253: SELECT expired_value
254: FROM pay_assignment_latest_balances
255: WHERE expired_assignment_action_id = c_assignment_action_id
256: AND assignment_id = c_assignment_id
257: AND defined_balance_id = c_defined_balance_id;
258: --

Line 497: from pay_assignment_latest_balances

493: --
494: cursor c1 (c_asg_action_id IN NUMBER,
495: c_defined_balance_id IN NUMBER)is
496: SELECT value, assignment_id
497: from pay_assignment_latest_balances
498: Where assignment_action_id = c_asg_action_id
499: and defined_balance_id = c_defined_balance_id;
500: --
501: cursor action_context is

Line 917: -- Run balances will never have a value in pay_assignment_latest_balances

913: --
914: l_defined_bal_id := dimension_relevant(p_balance_type_id, '_ASG_RUN');
915: if l_defined_bal_id is not null then
916: --
917: -- Run balances will never have a value in pay_assignment_latest_balances
918: -- table, as they are only used for the duration of the payroll run.
919: -- We therefore don't need to check the table, time can be saved by
920: -- simply calling the route code, which is incidentally the most
921: -- performant (ie simple) route.