APPS.PAY_US_GEO_UPD_PKG dependencies on PAY_LATEST_BALANCES

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

1027: pacv_rec pacv_cur%ROWTYPE;
1028:
1029: -- Rosie Monge 10/17/2005 Bug 4602222
1030: --Retrieve affected rows in the pay_balance_context_values table
1031: --using the latest_balance_id's from the pay_latest_balances
1032: --table.
1033:
1034: CURSOR plbcv_cur(geocode VARCHAR2, assign_id NUMBER, personid NUMBER) IS
1035: SELECT distinct pbcv.context_id, pbcv.value, pbcv.latest_balance_id,

Line 1039: pay_latest_balances plb

1035: SELECT distinct pbcv.context_id, pbcv.value, pbcv.latest_balance_id,
1036: plb.assignment_action_id
1037: FROM ff_contexts fcon,
1038: pay_balance_context_values pbcv,
1039: pay_latest_balances plb
1040: WHERE plb.assignment_id = assign_id
1041: AND pbcv.latest_balance_id = plb.latest_balance_id
1042: AND pbcv.value = geocode
1043: AND fcon.context_id = pbcv.context_id

Line 2903: -- Update Pay_Latest_balances context values.

2899:
2900: hr_utility.set_location('pay_us_geo_upd_pkg.upgrade_geocodes',125);
2901:
2902: -- Rosie Monge 10/17/2005
2903: -- Update Pay_Latest_balances context values.
2904:
2905: OPEN plbcv_cur(main_old_juri_code, main_assign_id, main_person_id);
2906: hr_utility.set_location('pay_us_geo_upd_pkg.upgrade_geocodes',126 );
2907: LOOP

Line 2914: l_proc_stage := 'PAY_LATEST_BALANCES_CONTEXT';

2910: EXIT WHEN plbcv_cur%NOTFOUND;
2911:
2912: hr_utility.set_location('pay_us_geo_upd_pkg.upgrade_geocodes',127);
2913:
2914: l_proc_stage := 'PAY_LATEST_BALANCES_CONTEXT';
2915:
2916: balance_contexts(
2917: p_proc_type => main_proc_type,
2918: p_person_id => main_person_id,