APPS.PAY_NO_PAYSLIP_ARCHIVE dependencies on HR_ORGANIZATION_UNITS

Line 1318: ,hr_organization_units hou

1314: ,hla.address_line_2 AL2
1315: ,hla.address_line_3 AL3
1316: ,hla.postal_code postal_code
1317: FROM hr_locations_all hla
1318: ,hr_organization_units hou
1319: WHERE hou.organization_id = p_organization_id
1320: AND hou.location_id = hla.location_id;
1321: -------------
1322: CURSOR csr_organization_address(p_organization_id NUMBER) IS

Line 1330: hr_organization_units hoa

1326: ,hla.address_line_3 AL3
1327: ,hla.country country
1328: ,hla.postal_code postal_code
1329: FROM hr_locations_all hla,
1330: hr_organization_units hoa
1331: WHERE hla.location_id = hoa.location_id
1332: AND hoa.organization_id = p_organization_id
1333: AND p_effective_date BETWEEN hoa.date_from AND NVL(hoa.date_to,to_date('31-12-4712','DD-MM-YYYY'));
1334:

Line 1339: FROM hr_organization_units

1335: --------------
1336: /* Cursor to retrieve Business Group Id */
1337: CURSOR csr_bus_grp_id(p_organization_id NUMBER) IS
1338: SELECT business_group_id
1339: FROM hr_organization_units
1340: WHERE organization_id = p_organization_id;
1341: --------------
1342: /* Cursor to retrieve Currency */
1343: CURSOR csr_currency(p_bg_id NUMBER) IS

Line 1357: FROM HR_ORGANIZATION_UNITS o1

1353: /* Cursor to get the Legal Employer from Local Unit */
1354:
1355: CURSOR csr_legal_employer (p_organization_id NUMBER) IS
1356: SELECT hoi3.organization_id
1357: FROM HR_ORGANIZATION_UNITS o1
1358: , HR_ORGANIZATION_INFORMATION hoi1
1359: , HR_ORGANIZATION_INFORMATION hoi2
1360: , HR_ORGANIZATION_INFORMATION hoi3
1361: WHERE o1.business_group_id =l_bg_id

Line 1434: CURSOR csr_org_name (p_org_name hr_organization_units.name%type ) IS

1430: and ORG_INFORMATION_CONTEXT = 'NO_LEGAL_EMPLOYER_DETAILS' ;
1431:
1432:
1433: /* Cursor to get the Org name */
1434: CURSOR csr_org_name (p_org_name hr_organization_units.name%type ) IS
1435: SELECT name
1436: FROM hr_organization_units
1437: WHERE organization_id = p_org_name ;
1438:

Line 1436: FROM hr_organization_units

1432:
1433: /* Cursor to get the Org name */
1434: CURSOR csr_org_name (p_org_name hr_organization_units.name%type ) IS
1435: SELECT name
1436: FROM hr_organization_units
1437: WHERE organization_id = p_org_name ;
1438:
1439:
1440: /* cursor to get the primary assignment id */

Line 1469: l_organization hr_organization_units.name%TYPE;

1465: l_position per_all_positions.name%TYPE;
1466: l_hire_date per_periods_of_service.date_start%TYPE;
1467: l_grade per_grades.name%TYPE;
1468: l_currency hr_organization_information.org_information10%TYPE;
1469: l_organization hr_organization_units.name%TYPE;
1470: l_pay_location hr_locations_all.address_line_1%TYPE;
1471: l_postal_code VARCHAR2(80);
1472: l_country VARCHAR2(30);
1473: l_emp_postal_code VARCHAR2(80);

Line 1480: l_employer_name hr_organization_units.name%TYPE;

1476: l_org_country VARCHAR2(30);
1477: l_action_info_id NUMBER;
1478: l_ovn NUMBER;
1479: l_person_id NUMBER;
1480: l_employer_name hr_organization_units.name%TYPE;
1481: l_local_unit_id hr_organization_units.organization_id%TYPE;
1482: l_legal_employer_id hr_organization_units.organization_id%TYPE;
1483: l_job PER_JOBS.NAME%TYPE;
1484: l_org_struct_ver_id hr_organization_information.org_information1%TYPE;

Line 1481: l_local_unit_id hr_organization_units.organization_id%TYPE;

1477: l_action_info_id NUMBER;
1478: l_ovn NUMBER;
1479: l_person_id NUMBER;
1480: l_employer_name hr_organization_units.name%TYPE;
1481: l_local_unit_id hr_organization_units.organization_id%TYPE;
1482: l_legal_employer_id hr_organization_units.organization_id%TYPE;
1483: l_job PER_JOBS.NAME%TYPE;
1484: l_org_struct_ver_id hr_organization_information.org_information1%TYPE;
1485: l_top_org_id per_org_structure_elements.organization_id_parent%TYPE;

Line 1482: l_legal_employer_id hr_organization_units.organization_id%TYPE;

1478: l_ovn NUMBER;
1479: l_person_id NUMBER;
1480: l_employer_name hr_organization_units.name%TYPE;
1481: l_local_unit_id hr_organization_units.organization_id%TYPE;
1482: l_legal_employer_id hr_organization_units.organization_id%TYPE;
1483: l_job PER_JOBS.NAME%TYPE;
1484: l_org_struct_ver_id hr_organization_information.org_information1%TYPE;
1485: l_top_org_id per_org_structure_elements.organization_id_parent%TYPE;
1486: l_cost_center pay_cost_allocations_v.concatenated_segments%TYPE;

Line 4399: FROM hr_organization_units

4395:
4396: /* Cursor to retrieve Business Group Id */
4397: CURSOR csr_bus_grp_id(p_organization_id NUMBER) IS
4398: SELECT business_group_id
4399: FROM hr_organization_units
4400: WHERE organization_id = p_organization_id;
4401:
4402: -----------------------------------------
4403: