DBA Data[Home] [Help]

APPS.HR_GBBAL dependencies on PAY_ASSIGNMENT_LATEST_BALANCES

Line 657: from pay_assignment_latest_balances

653: --
654: cursor c1 (c_asg_action_id IN NUMBER,
655: c_defined_balance_id IN NUMBER)is
656: SELECT value, assignment_id
657: from pay_assignment_latest_balances
658: Where assignment_action_id = c_asg_action_id
659: and defined_balance_id = c_defined_balance_id;
660: --
661: cursor action_context is

Line 856: from pay_assignment_latest_balances palb,

852: cursor element_latest_bal(c_assignment_action_id IN NUMBER,
853: c_defined_bal_id IN NUMBER,
854: c_source_id IN NUMBER) is
855: select palb.value
856: from pay_assignment_latest_balances palb,
857: pay_balance_context_values pbcv
858: where pbcv.context_id = c_source_id
859: and pbcv.latest_balance_id = palb.latest_balance_id
860: and palb.assignment_action_id = c_assignment_action_id

Line 3656: from pay_assignment_latest_balances

3652:
3653: cursor csr_latest_bal (c_asg_action_id IN NUMBER,
3654: c_defined_balance_id IN NUMBER) is
3655: SELECT value
3656: from pay_assignment_latest_balances
3657: Where assignment_action_id = c_asg_action_id
3658: and defined_balance_id = c_defined_balance_id;
3659:
3660: cursor CSR_ni_entries is