APPS.PAY_FI_ARCHIVE_MTRA dependencies on PAY_RUN_BALANCES

Line 575: FROM pay_run_balances

571: BEGIN
572:
573: SELECT MAX(ASSIGNMENT_ACTION_ID)
574: INTO l_assignment_action_id
575: FROM pay_run_balances
576: WHERE local_unit_id = l_local_unit_id
577: AND TO_CHAR(effective_date,'MMYYYY')=l_month||l_year ;
578:
579: EXCEPTION

Line 709: FROM pay_run_balances

705: BEGIN
706:
707: SELECT MAX(ASSIGNMENT_ACTION_ID)
708: INTO l_assignment_action_id
709: FROM pay_run_balances
710: WHERE tax_unit_id =l_legal_employer_id
711: AND TO_CHAR(effective_date,'MMYYYY')=l_month||l_year ;
712:
713: EXCEPTION