APPS.PAY_MX_SOC_SEC_ARCHIVE dependencies on HR_ORGANIZATION_UNITS

Line 989: FROM hr_organization_units

985: AND organization_id = cp_organization_id ;
986:
987: CURSOR c_org_name ( cp_organization_id IN NUMBER) IS
988: SELECT name
989: FROM hr_organization_units
990: WHERE organization_id = cp_organization_id;
991:
992: CURSOR c_waybill_of_trnsmtr ( cp_organization_id IN NUMBER) IS
993: SELECT org_information5 WayBill_Number

Line 4166: FROM hr_organization_units hou,

4162: FUNCTION get_IDW_calc_method(p_org_id IN NUMBER
4163: ,p_effective_date IN DATE) RETURN VARCHAR2 IS
4164: CURSOR c_get_idw_calc_method IS
4165: SELECT hoi.org_information10
4166: FROM hr_organization_units hou,
4167: hr_organization_information hoi
4168: WHERE hou.organization_id = p_org_id
4169: AND hoi.org_information_context ='MX_SOC_SEC_DETAILS'
4170: AND hou.organization_id = hoi.organization_id

Line 4362: ln_business_group_id hr_organization_units.organization_id%TYPE;

4358:
4359: lv_procedure_name VARCHAR2(200);
4360: lv_end_date VARCHAR2(19);
4361: lv_start_date VARCHAR2(19);
4362: ln_business_group_id hr_organization_units.organization_id%TYPE;
4363: ln_gre_id hr_organization_units.organization_id%TYPE;
4364: ln_pactid NUMBER;
4365: lv_msg_txt VARCHAR2(250); -- Bug 13357684
4366: lv_gre_name VARCHAR2(200); -- Bug 13357684

Line 4363: ln_gre_id hr_organization_units.organization_id%TYPE;

4359: lv_procedure_name VARCHAR2(200);
4360: lv_end_date VARCHAR2(19);
4361: lv_start_date VARCHAR2(19);
4362: ln_business_group_id hr_organization_units.organization_id%TYPE;
4363: ln_gre_id hr_organization_units.organization_id%TYPE;
4364: ln_pactid NUMBER;
4365: lv_msg_txt VARCHAR2(250); -- Bug 13357684
4366: lv_gre_name VARCHAR2(200); -- Bug 13357684
4367: