APPS.PAY_MX_SOC_SEC_ARCHIVE dependencies on HR_ORGANIZATION_INFORMATION

Line 342: gv_IDW_calc_method hr_organization_information.org_information10%type;

338: gv_crdt_grant_dt VARCHAR2(240);
339: gv_discount_type VARCHAR2(240);
340: gv_discount_value VARCHAR2(240);
341: gv_variable_idw VARCHAR2(10);
342: gv_IDW_calc_method hr_organization_information.org_information10%type;
343:
344: PROCEDURE hr_utility_trace (p_data IN VARCHAR2) IS
345: BEGIN
346: IF gv_debug THEN

Line 512: FROM hr_organization_information

508:
509:
510: CURSOR c_get_imp_date(cp_organization_id IN NUMBER) IS
511: SELECT fnd_date.canonical_to_date(org_information6)
512: FROM hr_organization_information
513: WHERE org_information_context = 'MX_TAX_REGISTRATION'
514: AND organization_id = cp_organization_id ;
515:
516: ld_report_imp_date date;

Line 983: FROM hr_organization_information

979: SELECT replace(org_information1,'-','') Social_Security_ID
980: ,org_information3 Transmitter_Yes_No
981: ,org_information5 WayBill_Number
982: ,org_information6 Transmitter_GRE_ID
983: FROM hr_organization_information
984: WHERE org_information_context = 'MX_SOC_SEC_DETAILS'
985: AND organization_id = cp_organization_id ;
986:
987: CURSOR c_org_name ( cp_organization_id IN NUMBER) IS

Line 994: FROM hr_organization_information

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
994: FROM hr_organization_information
995: WHERE org_information_context = 'MX_SOC_SEC_DETAILS'
996: AND organization_id = cp_organization_id ;
997:
998: lv_soc_sec_id VARCHAR2(240);

Line 1317: FROM hr_organization_information

1313: 'Eligible Compensation for IDW (Variable Basis)') > 0;
1314:
1315: CURSOR c_get_org_information ( cp_organization_id IN NUMBER) IS
1316: SELECT replace(org_information1,'-','') Social_Security_ID
1317: FROM hr_organization_information
1318: WHERE org_information_context = 'MX_SOC_SEC_DETAILS'
1319: AND organization_id = cp_organization_id ;
1320:
1321: CURSOR c_person_detail (cp_person_id IN NUMBER

Line 2499: FROM hr_organization_information

2495:
2496:
2497: CURSOR c_get_org_information ( cp_organization_id IN NUMBER) IS
2498: SELECT replace(org_information1,'-','') Social_Security_ID
2499: FROM hr_organization_information
2500: WHERE org_information_context = 'MX_SOC_SEC_DETAILS'
2501: AND organization_id = cp_organization_id ;
2502:
2503: CURSOR c_person_detail (cp_person_id IN NUMBER

Line 4167: hr_organization_information hoi

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
4171: AND p_effective_date BETWEEN hou.date_from

Line 4174: lv_idw_calc_method hr_organization_information.org_information10%type;

4170: AND hou.organization_id = hoi.organization_id
4171: AND p_effective_date BETWEEN hou.date_from
4172: AND nvl(hou.date_to,p_effective_date);
4173:
4174: lv_idw_calc_method hr_organization_information.org_information10%type;
4175: BEGIN
4176: OPEN c_get_idw_calc_method;
4177: FETCH c_get_idw_calc_method INTO lv_idw_calc_method;
4178: CLOSE c_get_idw_calc_method;