DBA Data[Home] [Help]

APPS.PAY_KW_MONTHLY_REPORTS dependencies on HR_LOCATIONS

Line 1083: FROM hr_locations hl

1079:
1080: /* Cursor for fetching Employer's Address */
1081: CURSOR csr_get_address IS
1082: SELECT address_line_1 || decode(address_line_2,null,null,',') || address_line_2 || decode(postal_code,null,null,',')|| postal_code
1083: FROM hr_locations hl
1084: , hr_organization_units hou /*hr_all_organization_units hou*/
1085: WHERE hl.location_id = hou.location_id
1086: AND hou.organization_id = p_employer_id;
1087: