[Home] [Help]
2518: --=========================================================================
2519: -- Cursor to check if ABP employer details are present in current Org
2520: CURSOR csr_chk_er_details(c_org_id IN Number) IS
2521: SELECT 1
2522: FROM hr_organization_information
2523: WHERE org_information_context = 'PQP_ABP_PROVIDER'
2524: AND organization_id = c_org_id;
2525: --=========================================================================
2526: -- Cursor to fetch ABP employer payroll. Within one employer it is not allowed
2531: ,c_abp_org_id IN NUMBER)
2532: IS
2533: SELECT ppf.payroll_id
2534: FROM pay_payrolls_f ppf
2535: ,hr_organization_information hoi
2536: WHERE hoi.org_information_context = 'PQP_ABP_PROVIDER'
2537: AND hoi.organization_id = c_abp_org_id
2538: AND ppf.prl_information1 = to_char (c_tax_unit_id)
2539: AND ppf.business_group_id = c_bg_id
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
2789: AND org_information_context = 'PQP_NL_ABP_PTP_METHOD';
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
4555: AND hoi.organization_id = hou.organization_id
4578: ,'VWK') freq
4579: ,substr (org_information6
4580: ,1
4581: ,10) ref_er
4582: FROM hr_organization_information
4583: WHERE org_information_context = 'PQP_ABP_PROVIDER'
4584: AND organization_id = c_org_id;
4585: --=========================================================================
4586: CURSOR csr_get_employer(p_org_id IN NUMBER) IS