DBA Data[Home] [Help]

APPS.PAY_IN_PAYSLIP_ARCHIVE dependencies on HR_LOCATIONS_ALL

Line 3111: ,hr_locations_all hla

3107: ,1,240)
3108: FROM hr_organization_information hoi
3109: ,hr_organization_units hou
3110: ,hr_organization_units hou1
3111: ,hr_locations_all hla
3112: WHERE hoi.organization_id=p_organization_id
3113: AND hoi.org_information_context = DECODE(p_context,'PF','PER_IN_PF_DF','ESI','PER_IN_ESI_DF')
3114: AND hou.organization_id = DECODE (p_context,'PF',hoi.org_information8,'ESI',hoi.org_information2)
3115: AND hla.location_id=hou1.location_id

Line 3797: ,hr_locations_all hla

3793: ,1,240)
3794: FROM hr_organization_information hoi
3795: ,hr_organization_units hou
3796: ,hr_organization_units hou1
3797: ,hr_locations_all hla
3798: WHERE hoi.organization_id = p_organization_id
3799: AND hoi.org_information_context = 'PER_IN_PROF_TAX_DF'
3800: AND hou.organization_id = hoi.org_information2
3801: AND hla.location_id = hou1.location_id