APPS.PAY_US_GEO_UPD_PKG dependencies on PAY_ASSIGNMENT_LATEST_BALANCES

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

1209:
1210: pbcv_rec pbcv_cur%ROWTYPE;
1211:
1212: --Retrieve affected rows in the pay_balance_context_values table
1213: --using the latest_balance_id's from the pay_assignment_latest_balances
1214: --table.
1215: CURSOR pacv_cur(geocode VARCHAR2, assign_id NUMBER, personid NUMBER) IS
1216: SELECT distinct pbcv.context_id, pbcv.value, pbcv.latest_balance_id,
1217: plb.assignment_action_id

Line 1220: pay_assignment_latest_balances plb

1216: SELECT distinct pbcv.context_id, pbcv.value, pbcv.latest_balance_id,
1217: plb.assignment_action_id
1218: FROM ff_contexts fcon,
1219: pay_balance_context_values pbcv,
1220: pay_assignment_latest_balances plb
1221: WHERE plb.assignment_id = assign_id
1222: AND pbcv.latest_balance_id = plb.latest_balance_id
1223: AND pbcv.value = geocode
1224: AND fcon.context_id = pbcv.context_id