APPS.PAY_US_GEO_UPD_PKG dependencies on PAY_LATEST_BALANCES

Line 1240: --using the latest_balance_id's from the pay_latest_balances

1236: pacv_rec pacv_cur%ROWTYPE;
1237:
1238: -- Rosie Monge 10/17/2005 Bug 4602222
1239: --Retrieve affected rows in the pay_balance_context_values table
1240: --using the latest_balance_id's from the pay_latest_balances
1241: --table.
1242:
1243: CURSOR plbcv_cur(geocode VARCHAR2, assign_id NUMBER, personid NUMBER) IS
1244: SELECT distinct pbcv.context_id, pbcv.value, pbcv.latest_balance_id,

Line 1248: pay_latest_balances plb

1244: SELECT distinct pbcv.context_id, pbcv.value, pbcv.latest_balance_id,
1245: plb.assignment_action_id
1246: FROM ff_contexts fcon,
1247: pay_balance_context_values pbcv,
1248: pay_latest_balances plb
1249: WHERE plb.assignment_id = assign_id
1250: AND pbcv.latest_balance_id = plb.latest_balance_id
1251: AND pbcv.value = geocode
1252: AND fcon.context_id = pbcv.context_id

Line 3196: -- Update Pay_Latest_balances context values.

3192:
3193: hr_utility.set_location('pay_us_geo_upd_pkg.upgrade_geocodes',125);
3194:
3195: -- Rosie Monge 10/17/2005
3196: -- Update Pay_Latest_balances context values.
3197:
3198: OPEN plbcv_cur(main_old_juri_code, main_assign_id, main_person_id);
3199: hr_utility.set_location('pay_us_geo_upd_pkg.upgrade_geocodes',126 );
3200: LOOP

Line 3207: l_proc_stage := 'PAY_LATEST_BALANCES_CONTEXT';

3203: EXIT WHEN plbcv_cur%NOTFOUND;
3204:
3205: hr_utility.set_location('pay_us_geo_upd_pkg.upgrade_geocodes',127);
3206:
3207: l_proc_stage := 'PAY_LATEST_BALANCES_CONTEXT';
3208:
3209: balance_contexts(
3210: p_proc_type => main_proc_type,
3211: p_person_id => main_person_id,