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_MX_TRR_PKG dependencies on PER_MX_GRES_LEGAL_EMPLOYER_V

Line 453: FROM per_mx_gres_legal_employer_v pmx

449: p_state_code IN VARCHAR2,
450: p_gre_id IN NUMBER) IS
451: SELECT DISTINCT pmx.state state_code,
452: pmx.state_name state_name
453: FROM per_mx_gres_legal_employer_v pmx
454: WHERE pmx.business_group_id = p_business_group_id
455: AND fnd_number.canonical_to_number(pmx.legal_employer_id) = fnd_number.canonical_to_number(p_legal_employer_id)
456: --AND pmx.legal_employer_id = p_legal_employer_id
457: AND (( p_state_code IS NULL ) OR ( p_state_code IS NOT NULL and

Line 470: FROM per_mx_gres_legal_employer_v pmx

466: p_state IN VARCHAR2) IS
467: SELECT pmx.tax_unit_id tax_unit_id,
468: pmx.gre_name gre_name,
469: pmx.ss_id
470: FROM per_mx_gres_legal_employer_v pmx
471: WHERE pmx.business_group_id = p_business_group_id
472: AND fnd_number.canonical_to_number(pmx.legal_employer_id) = fnd_number.canonical_to_number(p_legal_employer_id)
473: AND (( p_state IS NULL ) OR ( p_state IS NOT NULL and
474: p_state = pmx.state))