DBA Data[Home] [Help]

APPS.PAY_US_GEO_UPD_PKG dependencies on PAY_PERSON_LATEST_BALANCES

Line 1182: --using the latest_balance_id's from the pay_person_latest_balances

1178: and pugu.id = g_geo_phase_id);
1179: fac_rec fac_cur%ROWTYPE;
1180:
1181: --Retrieve affected rows in the pay_balance_context_values table
1182: --using the latest_balance_id's from the pay_person_latest_balances
1183: --table.
1184: --Since we can join by the pk of the table we do not need any more logic
1185: --in the balance_contexts procedure.
1186:

Line 1192: pay_person_latest_balances plb,

1188: SELECT distinct pbcv.context_id, pbcv.value, pbcv.latest_balance_id,
1189: plb.assignment_action_id
1190: FROM pay_assignment_actions paa,
1191: pay_balance_context_values pbcv,
1192: pay_person_latest_balances plb,
1193: ff_contexts fcon
1194: WHERE paa.assignment_id = assign_id
1195: AND paa.assignment_action_id = plb.assignment_action_id
1196: AND plb.person_id = personid