DBA Data[Home] [Help]

APPS.PAY_MX_TRR_PKG dependencies on PER_MX_GRES_LEGAL_EMPLOYER_V

Line 436: FROM per_mx_gres_legal_employer_v pmx

432: p_state_code IN VARCHAR2,
433: p_gre_id IN NUMBER) IS
434: SELECT DISTINCT pmx.state state_code,
435: pmx.state_name state_name
436: FROM per_mx_gres_legal_employer_v pmx
437: WHERE pmx.business_group_id = p_business_group_id
438: AND pmx.legal_employer_id = p_legal_employer_id
439: AND pmx.legal_employer_id = p_legal_employer_id
440: AND (( p_state_code IS NULL ) OR ( p_state_code IS NOT NULL and

Line 453: FROM per_mx_gres_legal_employer_v pmx

449: p_state IN VARCHAR2) IS
450: SELECT pmx.tax_unit_id tax_unit_id,
451: pmx.gre_name gre_name,
452: pmx.ss_id
453: FROM per_mx_gres_legal_employer_v pmx
454: WHERE pmx.business_group_id = p_business_group_id
455: AND pmx.legal_employer_id = p_legal_employer_id
456: AND (( p_state IS NULL ) OR ( p_state IS NOT NULL and
457: p_state = pmx.state))