APPS.PAY_NL_ABP_ARCHIVE dependencies on PER_ORG_STRUCTURE_VERSIONS

Line 2375: ,per_org_structure_versions posv

2371: SELECT DISTINCT
2372: paa.assignment_id assignment_id
2373: ,paa.person_id
2374: FROM pay_payroll_actions ppa
2375: ,per_org_structure_versions posv
2376: ,per_all_assignments_f paa
2377: ,per_all_people_f pap
2378: WHERE posv.organization_structure_id = c_org_struct_id
2379: AND posv.date_from <= c_end_date

Line 2565: l_version_id per_org_structure_versions_v.org_structure_version_id%TYPE DEFAULT NULL;

2561: l_chk NUMBER := 0;
2562: abp_provider_found VARCHAR2(3);
2563: l_loop_again NUMBER;
2564: l_chk_er_details csr_chk_er_details%ROWTYPE;
2565: l_version_id per_org_structure_versions_v.org_structure_version_id%TYPE DEFAULT NULL;
2566:
2567: --=========================================================================
2568: PROCEDURE ins_assg_act (p_assignid IN NUMBER
2569: ,p_pactid IN NUMBER

Line 4644: l_version_id per_org_structure_versions_v.org_structure_version_id%TYPE DEFAULT NULL;

4640: l_ovn NUMBER;
4641: l_er_num VARCHAR2(10);
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);