APPS.PAY_US_GEO_UPD_PKG dependencies on PAY_PERSON_LATEST_BALANCES

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

969: and pugu.id = g_geo_phase_id);
970: fac_rec fac_cur%ROWTYPE;
971:
972: --Retrieve affected rows in the pay_balance_context_values table
973: --using the latest_balance_id's from the pay_person_latest_balances
974: --table.
975: --Since we can join by the pk of the table we do not need any more logic
976: --in the balance_contexts procedure.
977:

Line 983: pay_person_latest_balances plb,

979: SELECT distinct pbcv.context_id, pbcv.value, pbcv.latest_balance_id,
980: plb.assignment_action_id
981: FROM pay_assignment_actions paa,
982: pay_balance_context_values pbcv,
983: pay_person_latest_balances plb,
984: ff_contexts fcon
985: WHERE paa.assignment_id = assign_id
986: AND paa.assignment_action_id = plb.assignment_action_id
987: AND plb.person_id = personid