APPS.PAY_NL_ABP_ARCHIVE dependencies on HR_ORGANIZATION_UNITS

Line 2784: FROM hr_organization_units hou

2780: SELECT nvl (org_information4
2781: ,0) override
2782: ,nvl (org_information5
2783: ,1) start_pos
2784: FROM hr_organization_units hou
2785: ,hr_organization_information hoi
2786: WHERE hou.organization_id = c_org_id
2787: AND hou.business_group_id = c_bg_id
2788: AND hoi.organization_id = hou.organization_id

Line 4550: FROM hr_organization_units hou

4546: ,c_bg_id IN NUMBER) IS
4547: SELECT org_information1 reg_num_sender
4548: ,decode(org_information2,'Y','T','N','P') prod_test
4549: ,substr(org_information3,1,45) name_sender
4550: FROM hr_organization_units hou
4551: ,hr_organization_information hoi
4552: WHERE hou.organization_id = nvl (c_org_id
4553: ,c_bg_id)
4554: AND hou.business_group_id = c_bg_id

Line 4588: FROM hr_organization_units

4584: AND organization_id = c_org_id;
4585: --=========================================================================
4586: CURSOR csr_get_employer(p_org_id IN NUMBER) IS
4587: SELECT name
4588: FROM hr_organization_units
4589: WHERE organization_id = p_org_id;
4590: --=========================================================================
4591: CURSOR csr_get_PA_exception_info(p_payroll_action_id IN NUMBER) IS
4592: SELECT pai_p.action_information4 Message

Line 4646: l_er_name hr_organization_units.name%TYPE;

4642: l_freq VARCHAR2(10);
4643: l_ref_er VARCHAR2(10);
4644: l_version_id per_org_structure_versions_v.org_structure_version_id%TYPE DEFAULT NULL;
4645: l_loop_again NUMBER;
4646: l_er_name hr_organization_units.name%TYPE;
4647: empr_flag VARCHAR2(1);
4648: empe_flag VARCHAR2(1);
4649: l_exception_flag VARCHAR2(1);
4650: