eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_FI_ARCHIVE_LTFA dependencies on PAY_RUN_BALANCES

Line 402: FROM pay_run_balances

398: BEGIN
399:
400: SELECT MAX(ASSIGNMENT_ACTION_ID)
401: INTO g_lu_assignment_action_id
402: FROM pay_run_balances
403: WHERE local_unit_id = g_local_unit_id
404: AND organization_id =g_pension_provider
405: AND TO_CHAR(effective_date,'MMYYYY')=l_month||l_year ;
406:

Line 456: FROM pay_run_balances

452: BEGIN
453:
454: SELECT MAX(ASSIGNMENT_ACTION_ID)
455: INTO g_le_assignment_action_id
456: FROM pay_run_balances
457: WHERE tax_unit_id =g_legal_employer_id
458: AND organization_id =g_pension_provider
459: AND TO_CHAR(effective_date,'MMYYYY')=l_month||l_year ;
460: