APPS.PAY_MX_SOC_SEC_ARCHIVE dependencies on HR_ORGANIZATION_INFORMATION

Line 306: gv_IDW_calc_method hr_organization_information.org_information10%type;

302: gv_crdt_grant_dt VARCHAR2(240);
303: gv_discount_type VARCHAR2(240);
304: gv_discount_value VARCHAR2(240);
305: gv_variable_idw VARCHAR2(10);
306: gv_IDW_calc_method hr_organization_information.org_information10%type;
307:
308: PROCEDURE hr_utility_trace (p_data IN VARCHAR2) IS
309: BEGIN
310: IF gv_debug THEN

Line 443: FROM hr_organization_information

439:
440:
441: CURSOR c_get_imp_date(cp_organization_id IN NUMBER) IS
442: SELECT fnd_date.canonical_to_date(org_information6)
443: FROM hr_organization_information
444: WHERE org_information_context = 'MX_TAX_REGISTRATION'
445: AND organization_id = cp_organization_id ;
446:
447: ld_report_imp_date date;

Line 912: FROM hr_organization_information

908: SELECT replace(org_information1,'-','') Social_Security_ID
909: ,org_information3 Transmitter_Yes_No
910: ,org_information5 WayBill_Number
911: ,org_information6 Transmitter_GRE_ID
912: FROM hr_organization_information
913: WHERE org_information_context = 'MX_SOC_SEC_DETAILS'
914: AND organization_id = cp_organization_id ;
915:
916: CURSOR c_org_name ( cp_organization_id IN NUMBER) IS

Line 923: FROM hr_organization_information

919: WHERE organization_id = cp_organization_id;
920:
921: CURSOR c_waybill_of_trnsmtr ( cp_organization_id IN NUMBER) IS
922: SELECT org_information5 WayBill_Number
923: FROM hr_organization_information
924: WHERE org_information_context = 'MX_SOC_SEC_DETAILS'
925: AND organization_id = cp_organization_id ;
926:
927: lv_soc_sec_id VARCHAR2(240);

Line 1242: FROM hr_organization_information

1238: 'Eligible Compensation for IDW (Variable Basis)') > 0;
1239:
1240: CURSOR c_get_org_information ( cp_organization_id IN NUMBER) IS
1241: SELECT replace(org_information1,'-','') Social_Security_ID
1242: FROM hr_organization_information
1243: WHERE org_information_context = 'MX_SOC_SEC_DETAILS'
1244: AND organization_id = cp_organization_id ;
1245:
1246: CURSOR c_person_detail (cp_person_id IN NUMBER

Line 2375: FROM hr_organization_information

2371:
2372:
2373: CURSOR c_get_org_information ( cp_organization_id IN NUMBER) IS
2374: SELECT replace(org_information1,'-','') Social_Security_ID
2375: FROM hr_organization_information
2376: WHERE org_information_context = 'MX_SOC_SEC_DETAILS'
2377: AND organization_id = cp_organization_id ;
2378:
2379: CURSOR c_person_detail (cp_person_id IN NUMBER

Line 3930: hr_organization_information hoi

3926: ,p_effective_date IN DATE) RETURN VARCHAR2 IS
3927: CURSOR c_get_idw_calc_method IS
3928: SELECT hoi.org_information10
3929: FROM hr_organization_units hou,
3930: hr_organization_information hoi
3931: WHERE hou.organization_id = p_org_id
3932: AND hoi.org_information_context ='MX_SOC_SEC_DETAILS'
3933: AND hou.organization_id = hoi.organization_id
3934: AND p_effective_date BETWEEN hou.date_from

Line 3937: lv_idw_calc_method hr_organization_information.org_information10%type;

3933: AND hou.organization_id = hoi.organization_id
3934: AND p_effective_date BETWEEN hou.date_from
3935: AND nvl(hou.date_to,p_effective_date);
3936:
3937: lv_idw_calc_method hr_organization_information.org_information10%type;
3938: BEGIN
3939: OPEN c_get_idw_calc_method;
3940: FETCH c_get_idw_calc_method INTO lv_idw_calc_method;
3941: CLOSE c_get_idw_calc_method;