APPS.PAY_US_GEO_UPD_PKG dependencies on PAY_ASSIGNMENT_LATEST_BALANCES

Line 1004: --using the latest_balance_id's from the pay_assignment_latest_balances

1000:
1001: pbcv_rec pbcv_cur%ROWTYPE;
1002:
1003: --Retrieve affected rows in the pay_balance_context_values table
1004: --using the latest_balance_id's from the pay_assignment_latest_balances
1005: --table.
1006: CURSOR pacv_cur(geocode VARCHAR2, assign_id NUMBER, personid NUMBER) IS
1007: SELECT distinct pbcv.context_id, pbcv.value, pbcv.latest_balance_id,
1008: plb.assignment_action_id

Line 1011: pay_assignment_latest_balances plb

1007: SELECT distinct pbcv.context_id, pbcv.value, pbcv.latest_balance_id,
1008: plb.assignment_action_id
1009: FROM ff_contexts fcon,
1010: pay_balance_context_values pbcv,
1011: pay_assignment_latest_balances plb
1012: WHERE plb.assignment_id = assign_id
1013: AND pbcv.latest_balance_id = plb.latest_balance_id
1014: AND pbcv.value = geocode
1015: AND fcon.context_id = pbcv.context_id