eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQP_NL_PENSION_EXTRACTS dependencies on HR_API

Line 2723: AND Nvl(date_to,Hr_Api.g_eot)

2719: hr_organization_information hoi
2720: WHERE hoi.organization_id = p_business_group_id
2721: AND To_Number(hoi.org_information1) = pos.organization_structure_id
2722: AND Trunc(p_effective_date) BETWEEN date_from
2723: AND Nvl(date_to,Hr_Api.g_eot)
2724: AND hoi.org_information_context = 'NL_BG_INFO';
2725:
2726: --Cursor to fetch immediate children of org
2727: CURSOR csr_get_children(c_org_id hr_all_organization_units.organization_id%TYPE,

Line 3477: l_date date := hr_api.g_eot;

3473: l_amount NUMBER;
3474: l_context_id NUMBER;
3475: l_si_type varchar2(4);
3476: l_code NUMBER;
3477: l_date date := hr_api.g_eot;
3478: l_new_start date;
3479: l_old_start date;
3480: l_new_start_can ben_ext_chg_evt_log.new_val1%TYPE;
3481: l_old_start_can ben_ext_chg_evt_log.old_val1%TYPE;

Line 5536: AND Nvl(date_to,Hr_Api.g_eot)

5532: hr_organization_information hoi
5533: WHERE hoi.organization_id = p_business_group_id
5534: AND To_Number(hoi.org_information1) = pos.organization_structure_id
5535: AND Trunc(p_effective_date) BETWEEN date_from
5536: AND Nvl(date_to,Hr_Api.g_eot)
5537: AND hoi.org_information_context = 'NL_BG_INFO';
5538: --
5539: -- Cursor to get the list of orgs from the hierarchy if one exists.
5540: --

Line 6534: AND nvl(date_to,hr_api.g_eot);

6530: SELECT org_structure_version_id
6531: FROM per_org_structure_versions_v
6532: WHERE organization_structure_id = c_hierarchy_id
6533: AND g_extract_params(p_business_group_id).extract_end_date BETWEEN date_from
6534: AND nvl(date_to,hr_api.g_eot);
6535:
6536: --
6537: -- Cursor to find the valid version id for a particular business group
6538: --

Line 6544: AND nvl( date_to,hr_api.g_eot);

6540: SELECT org_structure_version_id
6541: FROM per_org_structure_versions_v
6542: WHERE business_group_id = p_business_group_id
6543: AND g_extract_params(p_business_group_id).extract_end_date BETWEEN date_from
6544: AND nvl( date_to,hr_api.g_eot);
6545: --
6546: -- Cursor to find the parent id from the org id
6547: --
6548: CURSOR c_find_parent_id(c_org_id in number

Line 6868: AND Nvl(date_to,Hr_Api.g_eot)

6864: SELECT region_1
6865: FROM per_addresses_v
6866: WHERE person_id = c_person_id
6867: AND p_effective_date BETWEEN date_from
6868: AND Nvl(date_to,Hr_Api.g_eot)
6869: AND primary_flag = 'Y'
6870: AND style = 'NL'
6871: UNION
6872: SELECT address_line1

Line 6876: AND Nvl(date_to,Hr_Api.g_eot)

6872: SELECT address_line1
6873: FROM per_addresses_v
6874: WHERE person_id = c_person_id
6875: AND p_effective_date BETWEEN date_from
6876: AND Nvl(date_to,Hr_Api.g_eot)
6877: AND primary_flag = 'Y'
6878: AND style = 'NL_GLB';
6879:
6880: l_street per_addresses_v.region_1%TYPE;

Line 6918: AND Nvl(date_to,Hr_Api.g_eot)

6914: SELECT add_information13
6915: FROM per_addresses_v
6916: WHERE person_id = c_person_id
6917: AND p_effective_date BETWEEN date_from
6918: AND Nvl(date_to,Hr_Api.g_eot)
6919: AND style = 'NL'
6920: AND primary_flag = 'Y'
6921: UNION
6922: SELECT address_line2

Line 6926: AND Nvl(date_to,Hr_Api.g_eot)

6922: SELECT address_line2
6923: FROM per_addresses_v
6924: WHERE person_id = c_person_id
6925: AND p_effective_date BETWEEN date_from
6926: AND Nvl(date_to,Hr_Api.g_eot)
6927: AND style = 'NL_GLB'
6928: AND primary_flag = 'Y';
6929:
6930: l_house_num per_addresses_v.address_line1%TYPE;

Line 6973: AND Nvl(date_to,Hr_Api.g_eot)

6969: SELECT add_information14
6970: FROM per_addresses_v
6971: WHERE person_id = c_person_id
6972: AND p_effective_date BETWEEN date_from
6973: AND Nvl(date_to,Hr_Api.g_eot)
6974: AND primary_flag = 'Y'
6975: AND style = 'NL'
6976: UNION
6977: SELECT address_line3

Line 6981: AND Nvl(date_to,Hr_Api.g_eot)

6977: SELECT address_line3
6978: FROM per_addresses_v
6979: WHERE person_id = c_person_id
6980: AND p_effective_date BETWEEN date_from
6981: AND Nvl(date_to,Hr_Api.g_eot)
6982: AND primary_flag = 'Y'
6983: AND style = 'NL_GLB';
6984:
6985: l_addl_house_num per_addresses_v.address_line1%TYPE;

Line 7028: AND Nvl(date_to,Hr_Api.g_eot)

7024: SELECT postal_code
7025: FROM per_addresses_v
7026: WHERE person_id = c_person_id
7027: AND p_effective_date BETWEEN date_from
7028: AND Nvl(date_to,Hr_Api.g_eot)
7029: AND style IN ('NL','NL_GLB')
7030: AND primary_flag = 'Y';
7031:
7032: l_postal_code per_addresses_v.postal_code%TYPE;

Line 7088: AND Nvl(date_to,Hr_Api.g_eot)

7084: SELECT town_or_city
7085: FROM per_addresses_v
7086: WHERE person_id = c_person_id
7087: AND p_effective_date BETWEEN date_from
7088: AND Nvl(date_to,Hr_Api.g_eot)
7089: AND style IN ('NL','NL_GLB')
7090: AND primary_flag = 'Y';
7091:
7092: CURSOR cur_get_foreign_coun(c_person_id IN Number) IS

Line 7098: AND Nvl(date_to,Hr_Api.g_eot)

7094: ,d_country
7095: FROM per_addresses_v
7096: WHERE person_id = c_person_id
7097: AND p_effective_date BETWEEN date_from
7098: AND Nvl(date_to,Hr_Api.g_eot)
7099: AND style IN ('NL','NL_GLB')
7100: AND primary_flag = 'Y';
7101:
7102:

Line 7171: AND Nvl(date_to,Hr_Api.g_eot)

7167: SELECT Decode(country,'NL',' ','J')
7168: FROM per_addresses_v
7169: WHERE person_id = c_person_id
7170: AND p_effective_date BETWEEN date_from
7171: AND Nvl(date_to,Hr_Api.g_eot)
7172: AND style IN ('NL','NL_GLB')
7173: AND primary_flag = 'Y';
7174:
7175: l_country per_addresses_v.d_country%TYPE;

Line 7231: AND NVL(date_to,hr_api.g_eot)

7227: SELECT DECODE(country,'NL','N','J')
7228: FROM per_addresses_v
7229: WHERE person_id = c_person_id
7230: AND p_effective_date BETWEEN date_from
7231: AND NVL(date_to,hr_api.g_eot)
7232: AND style IN('NL','NL_GLB')
7233: AND primary_flag = 'Y';
7234:
7235: l_marital_status per_all_people_f.marital_status%TYPE;

Line 7293: AND TRUNC(NVL(fnd_date.canonical_to_date(aei_information2),hr_api.g_eot))

7289: AND information_type = 'NL_ABP_PAR_INFO'
7290: AND aei_information_category = 'NL_ABP_PAR_INFO'
7291: AND p_effective_date BETWEEN
7292: TRUNC(fnd_date.canonical_to_date(aei_information1))
7293: AND TRUNC(NVL(fnd_date.canonical_to_date(aei_information2),hr_api.g_eot))
7294: AND aei_information6 IS NOT NULL;
7295:
7296: l_ret_val NUMBER := 0;
7297: l_asg_action_id pay_assignment_actions.assignment_action_id%TYPE;

Line 7939: AND Nvl(date_end,Hr_Api.g_eot)

7935: SELECT contact_person_id
7936: FROM per_contact_relationships
7937: WHERE person_id = g_person_id
7938: AND p_effective_date BETWEEN date_start
7939: AND Nvl(date_end,Hr_Api.g_eot)
7940: AND contact_type IN ('S','D')
7941: AND business_group_id = p_business_group_id;
7942:
7943: --

Line 8140: AND NVL(date_to,hr_api.g_eot)

8136: SELECT DECODE(country,'NL','N','J')
8137: FROM per_addresses_v
8138: WHERE person_id = c_person_id
8139: AND p_effective_date BETWEEN date_from
8140: AND NVL(date_to,hr_api.g_eot)
8141: AND style IN('NL','NL_GLB')
8142: AND primary_flag = 'Y';
8143:
8144: --

Line 8183: AND p_effective_date BETWEEN date_from AND NVL(date_to,hr_api.g_eot)

8179: SELECT 1
8180: FROM per_addresses_v padr
8181: WHERE person_id = c_person_id
8182: -- if the current primary address is not in NL
8183: AND p_effective_date BETWEEN date_from AND NVL(date_to,hr_api.g_eot)
8184: AND primary_flag = 'Y'
8185: AND country <> 'NL'
8186: AND EXISTS (SELECT 1
8187: -- exists change in address event logs

Line 8208: AND p_effective_date BETWEEN date_from AND NVL(date_to,hr_api.g_eot)

8204: SELECT 1
8205: FROM per_addresses_v padr
8206: WHERE person_id = c_person_id
8207: -- if the current primary address is in NL
8208: AND p_effective_date BETWEEN date_from AND NVL(date_to,hr_api.g_eot)
8209: AND primary_flag = 'Y'
8210: AND country = 'NL'
8211: AND EXISTS (SELECT 1
8212: -- exists change in address event logs

Line 8253: AND p_effective_date BETWEEN date_from AND NVL(date_to,hr_api.g_eot)

8249: ,c_addr_id IN NUMBER) IS
8250: SELECT 1
8251: FROM per_addresses_v padr
8252: WHERE person_id = g_person_id
8253: AND p_effective_date BETWEEN date_from AND NVL(date_to,hr_api.g_eot)
8254: AND address_id = c_addr_id
8255: AND primary_flag = 'Y'
8256: AND country = c_code;
8257:

Line 9023: AND Nvl(date_to,Hr_Api.g_eot);

9019: SELECT ORG_STRUCTURE_VERSION_ID
9020: FROM per_org_structure_versions_v
9021: WHERE organization_structure_id = c_hierarchy_id
9022: AND p_effective_date BETWEEN date_from
9023: AND Nvl(date_to,Hr_Api.g_eot);
9024:
9025: --Cursor to find the valid version id for a particular business group
9026: CURSOR c_find_ver_frm_bg IS
9027: SELECT ORG_STRUCTURE_VERSION_ID

Line 9031: AND Nvl( date_to,Hr_Api.g_eot);

9027: SELECT ORG_STRUCTURE_VERSION_ID
9028: FROM per_org_structure_versions_v
9029: WHERE business_group_id = p_business_group_id
9030: AND p_effective_date BETWEEN date_from
9031: AND Nvl( date_to,Hr_Api.g_eot);
9032:
9033: --Cursor to find the parent id from the org id
9034: CURSOR c_find_parent_id(c_org_id IN Number
9035: ,c_version_id IN Number) IS

Line 9334: AND Nvl(date_to,Hr_Api.g_eot);

9330: SELECT ORG_STRUCTURE_VERSION_ID
9331: FROM per_org_structure_versions_v
9332: WHERE organization_structure_id = c_hierarchy_id
9333: AND p_date_earned BETWEEN date_from
9334: AND Nvl(date_to,Hr_Api.g_eot);
9335:
9336: --Cursor to find the valid version id for a particular business group
9337: CURSOR c_find_ver_frm_bg IS
9338: SELECT ORG_STRUCTURE_VERSION_ID

Line 9342: AND Nvl( date_to,Hr_Api.g_eot);

9338: SELECT ORG_STRUCTURE_VERSION_ID
9339: FROM per_org_structure_versions_v
9340: WHERE business_group_id = p_business_group_id
9341: AND p_date_earned BETWEEN date_from
9342: AND Nvl( date_to,Hr_Api.g_eot);
9343:
9344: --Cursor to find the parent id from the org id
9345: CURSOR c_find_parent_id(c_org_id IN Number
9346: ,c_version_id IN Number) IS

Line 9365: SELECT Fnd_Date.canonical_to_date(Nvl(hoi.org_information2,Fnd_Date.date_to_canonical(Hr_Api.g_eot)))

9361: AND hoi.organization_id = c_org_id;
9362:
9363: --Cursor to find the participation end date from org level information
9364: CURSOR c_get_org_info(c_org_id IN hr_organization_information.organization_id%TYPE) IS
9365: SELECT Fnd_Date.canonical_to_date(Nvl(hoi.org_information2,Fnd_Date.date_to_canonical(Hr_Api.g_eot)))
9366: FROM hr_organization_information hoi
9367: WHERE hoi.org_information_context = 'PQP_NL_ABP_PT'
9368: AND hoi.org_information3 = To_Char(p_pension_type_id)
9369: AND hoi.org_information6 = 'Y'

Line 9373: AND Fnd_Date.canonical_to_date(Nvl(hoi.org_information2,Fnd_Date.date_to_canonical(Hr_Api.g_eot)));

9369: AND hoi.org_information6 = 'Y'
9370: AND NVL(hoi.org_information7,'Y') = 'Y'
9371: AND hoi.organization_id = c_org_id
9372: AND p_date_earned BETWEEN Fnd_Date.canonical_to_date(hoi.org_information1)
9373: AND Fnd_Date.canonical_to_date(Nvl(hoi.org_information2,Fnd_Date.date_to_canonical(Hr_Api.g_eot)));
9374:
9375: BEGIN
9376: -- find the org the assignment is attached to
9377: OPEN c_find_org_id;

Line 9549: AND Nvl(date_to,Hr_Api.g_eot);

9545: SELECT ORG_STRUCTURE_VERSION_ID
9546: FROM per_org_structure_versions_v
9547: WHERE organization_structure_id = c_hierarchy_id
9548: AND p_effective_date BETWEEN date_from
9549: AND Nvl(date_to,Hr_Api.g_eot);
9550:
9551: --Cursor to find the valid version id for a particular business group
9552: CURSOR c_find_ver_frm_bg IS
9553: SELECT ORG_STRUCTURE_VERSION_ID

Line 9557: AND Nvl( date_to,Hr_Api.g_eot);

9553: SELECT ORG_STRUCTURE_VERSION_ID
9554: FROM per_org_structure_versions_v
9555: WHERE business_group_id = p_business_group_id
9556: AND p_effective_date BETWEEN date_from
9557: AND Nvl( date_to,Hr_Api.g_eot);
9558:
9559: --Cursor to find the parent id from the org id
9560: CURSOR c_find_parent_id(c_org_id IN Number
9561: ,c_version_id IN Number) IS

Line 9818: IF l_end_date = hr_api.g_eot THEN

9814: ,p_date_earned => p_effective_date
9815: ,p_end_date => l_end_date
9816: );
9817: IF l_ret_val = 0 THEN
9818: IF l_end_date = hr_api.g_eot THEN
9819: g_fur_dates(i).new_end := '';
9820: ELSE
9821: g_fur_dates(i).new_end := Fnd_Date.date_to_canonical(l_end_date) ;
9822: END IF;

Line 9927: fnd_date.date_to_canonical(hr_api.g_eot)));

9923: AND p_effective_date BETWEEN pty.effective_start_date and pty.effective_end_date
9924: AND pty.pension_sub_category IN ('PPP')
9925: AND p_effective_date between fnd_date.canonical_to_date(paei.aei_information1)
9926: AND fnd_date.canonical_to_date(NVL(paei.aei_information2,
9927: fnd_date.date_to_canonical(hr_api.g_eot)));
9928:
9929: /* Cursor changed for 6670714
9930: CURSOR c_rr_cur IS
9931: SELECT 1

Line 9971: fnd_date.date_to_canonical(hr_api.g_eot))))

9967: AND ( NVL(hoi1.org_information6,'N')= 'N'
9968: OR NVL(hoi1.org_information7,'N')= 'N')
9969: AND p_effective_date BETWEEN fnd_date.canonical_to_date(hoi1.org_information1)
9970: AND fnd_date.canonical_to_date(NVL(hoi1.org_information2,
9971: fnd_date.date_to_canonical(hr_api.g_eot))))
9972: ))
9973: AND hoi.org_information_context = 'PQP_NL_ABP_PT'
9974: AND hoi.org_information3 = TO_CHAR(pty.pension_type_id)
9975: AND p_effective_date BETWEEN pty.effective_start_date AND pty.effective_end_date

Line 9981: fnd_date.date_to_canonical(hr_api.g_eot)));

9977: AND NVL(hoi.org_information6,'N') = 'Y'
9978: AND NVL(hoi.org_information7,'N') = 'Y'
9979: AND p_effective_date BETWEEN fnd_date.canonical_to_date(hoi.org_information1)
9980: AND fnd_date.canonical_to_date(NVL(hoi.org_information2,
9981: fnd_date.date_to_canonical(hr_api.g_eot)));
9982:
9983:
9984: BEGIN
9985: Hr_Utility.set_location('Entering ------ : '||l_proc_name,10);

Line 10123: fnd_date.date_to_canonical(hr_api.g_eot))))

10119: AND ( NVL(hoi1.org_information6,'N')= 'N'
10120: OR NVL(hoi1.org_information7,'N')= 'N')
10121: AND p_effective_date BETWEEN fnd_date.canonical_to_date(hoi1.org_information1)
10122: AND fnd_date.canonical_to_date(NVL(hoi1.org_information2,
10123: fnd_date.date_to_canonical(hr_api.g_eot))))
10124: ))
10125: AND hoi.org_information_context = 'PQP_NL_ABP_PT'
10126: AND hoi.org_information3 = TO_CHAR(pty.pension_type_id)
10127: AND p_effective_date BETWEEN pty.effective_start_date AND pty.effective_end_date

Line 10137: fnd_date.date_to_canonical(hr_api.g_eot)))

10133: AND NVL(hoi.org_information6,'N') = 'Y'
10134: AND NVL(hoi.org_information7,'N') = 'Y'
10135: AND p_effective_date BETWEEN fnd_date.canonical_to_date(hoi.org_information1)
10136: AND fnd_date.canonical_to_date(NVL(hoi.org_information2,
10137: fnd_date.date_to_canonical(hr_api.g_eot)))
10138: AND NOT EXISTS (SELECT 1
10139: FROM per_assignment_extra_info paei1
10140: WHERE paei1.information_type='NL_ABP_RI'
10141: AND paei1.aei_information_category='NL_ABP_RI'

Line 10146: fnd_date.date_to_canonical(hr_api.g_eot))));

10142: AND paei1.assignment_id = p_assignment_id
10143: AND paei1.aei_information3 = 'G'
10144: AND p_effective_date BETWEEN fnd_date.canonical_to_date(paei1.aei_information1)
10145: AND fnd_date.canonical_to_date(NVL(paei1.aei_information2,
10146: fnd_date.date_to_canonical(hr_api.g_eot))));
10147:
10148: CURSOR c_fpu_asg IS
10149: SELECT DISTINCT DECODE (pty.pension_sub_category,'FPU_B','S'
10150: ,'FPU_C','S'

Line 10169: fnd_date.date_to_canonical(hr_api.g_eot)))

10165: 'FPU_S',
10166: 'FPU_T')
10167: AND p_effective_date between fnd_date.canonical_to_date(paei.aei_information1)
10168: AND fnd_date.canonical_to_date(NVL(paei.aei_information2,
10169: fnd_date.date_to_canonical(hr_api.g_eot)))
10170: AND NOT EXISTS (SELECT 1
10171: FROM per_assignment_extra_info paei1
10172: WHERE paei1.information_type='NL_ABP_RI'
10173: AND paei1.aei_information_category='NL_ABP_RI'

Line 10178: fnd_date.date_to_canonical(hr_api.g_eot))));

10174: AND paei1.assignment_id = p_assignment_id
10175: AND paei1.aei_information3 = 'G'
10176: AND p_effective_date BETWEEN fnd_date.canonical_to_date(paei1.aei_information1)
10177: AND fnd_date.canonical_to_date(NVL(paei1.aei_information2,
10178: fnd_date.date_to_canonical(hr_api.g_eot))));
10179:
10180: BEGIN
10181:
10182: Hr_Utility.set_location('Entering ------ : '||l_proc_name,5);

Line 10240: AND Fnd_Date.canonical_to_date(Nvl(aei_information2,Fnd_Date.date_to_canonical(Hr_Api.g_eot)))

10236: SELECT Substr(Nvl(aei_information4,'G'),0,1)
10237: FROM per_assignment_extra_info
10238: WHERE assignment_id = p_assignment_id
10239: AND p_effective_date BETWEEN Fnd_Date.canonical_to_date(aei_information1)
10240: AND Fnd_Date.canonical_to_date(Nvl(aei_information2,Fnd_Date.date_to_canonical(Hr_Api.g_eot)))
10241: AND aei_information_category = 'NL_ABP_RI'
10242: AND information_type = 'NL_ABP_RI';
10243:
10244: BEGIN

Line 10658: AND Fnd_Date.canonical_to_date(Nvl(aei_information2,Fnd_Date.date_to_canonical(Hr_Api.g_eot)));

10654: WHERE information_type = 'NL_ABP_PAR_INFO'
10655: AND aei_information_category = 'NL_ABP_PAR_INFO'
10656: AND assignment_id = p_assignment_id
10657: AND p_effective_date BETWEEN Fnd_Date.canonical_to_date(aei_information1)
10658: AND Fnd_Date.canonical_to_date(Nvl(aei_information2,Fnd_Date.date_to_canonical(Hr_Api.g_eot)));
10659: --
10660: -- Cursor to get the hire date of the person
10661: --
10662: CURSOR c_hire_dt IS

Line 11909: AND Nvl(date_to,Hr_Api.g_eot);

11905: SELECT ORG_STRUCTURE_VERSION_ID
11906: FROM per_org_structure_versions_v
11907: WHERE organization_structure_id = c_hierarchy_id
11908: AND p_effective_date BETWEEN date_from
11909: AND Nvl(date_to,Hr_Api.g_eot);
11910:
11911: --Cursor to find the valid version id for a particular business group
11912: CURSOR c_find_ver_frm_bg IS
11913: SELECT ORG_STRUCTURE_VERSION_ID

Line 11917: AND Nvl( date_to,Hr_Api.g_eot);

11913: SELECT ORG_STRUCTURE_VERSION_ID
11914: FROM per_org_structure_versions_v
11915: WHERE business_group_id = p_business_group_id
11916: AND p_effective_date BETWEEN date_from
11917: AND Nvl( date_to,Hr_Api.g_eot);
11918:
11919: --Cursor to find the parent id from the org id
11920: CURSOR c_find_parent_id(c_org_id IN Number
11921: ,c_version_id IN Number) IS

Line 12176: IF l_end_date = hr_api.g_eot THEN

12172: ,p_date_earned => p_effective_date
12173: ,p_end_date => l_end_date
12174: );
12175: IF l_ret_val = 0 THEN
12176: IF l_end_date = hr_api.g_eot THEN
12177: g_ipap_dates(i).new_end := '';
12178: ELSE
12179: g_ipap_dates(i).new_end := Fnd_Date.date_to_canonical(l_end_date) ;
12180: END IF;

Line 12485: fnd_date.date_to_canonical(hr_api.g_eot)))

12481: AND aei_information_category = 'NL_ABP_PAR_INFO'
12482: AND information_type = 'NL_ABP_PAR_INFO'
12483: AND trunc(c_nh_date) BETWEEN fnd_date.canonical_to_date(aei_information1)
12484: AND fnd_date.canonical_to_date(nvl(aei_information2,
12485: fnd_date.date_to_canonical(hr_api.g_eot)))
12486: AND aei_information6 IS NOT NULL;
12487:
12488: CURSOR c_get_override_salary (c_start IN DATE, c_end IN DATE) IS
12489: SELECT fnd_number.canonical_to_number(nvl(new_val1,'0'))

Line 13959: AND Fnd_Date.canonical_to_date(Nvl(aei_information2,Fnd_Date.date_to_canonical(Hr_Api.g_eot)))

13955: SELECT Substr(Nvl(aei_information7,'D'),0,1)
13956: FROM per_assignment_extra_info
13957: WHERE assignment_id = p_assignment_id
13958: AND p_effective_date BETWEEN Fnd_Date.canonical_to_date(aei_information1)
13959: AND Fnd_Date.canonical_to_date(Nvl(aei_information2,Fnd_Date.date_to_canonical(Hr_Api.g_eot)))
13960: AND aei_information_category = 'NL_ABP_RI'
13961: AND information_type = 'NL_ABP_RI';
13962:
13963: BEGIN

Line 14042: AND Fnd_Date.canonical_to_date(Nvl(aei_information2,Fnd_Date.date_to_canonical(Hr_Api.g_eot)));

14038: WHERE assignment_id = p_assignment_id
14039: AND aei_information_category = 'NL_ABP_RI'
14040: AND information_type = 'NL_ABP_RI'
14041: AND p_effective_date BETWEEN Fnd_Date.canonical_to_date(aei_information1)
14042: AND Fnd_Date.canonical_to_date(Nvl(aei_information2,Fnd_Date.date_to_canonical(Hr_Api.g_eot)));
14043:
14044: l_proc_name Varchar2(30) := 'Get_Ins_Typ_Anw_Ipap';
14045: l_anw_type Varchar2(2) := '01';
14046: l_ipap_type Varchar2(2) := '01';

Line 14093: AND Fnd_Date.canonical_to_date(Nvl(aei_information2,Fnd_Date.date_to_canonical(Hr_Api.g_eot)))

14089: WHERE information_type = 'NL_USZO_INFO'
14090: AND aei_information_category = 'NL_USZO_INFO'
14091: AND assignment_id = p_assignment_id
14092: AND p_effective_date BETWEEN Fnd_Date.canonical_to_date(aei_information1)
14093: AND Fnd_Date.canonical_to_date(Nvl(aei_information2,Fnd_Date.date_to_canonical(Hr_Api.g_eot)))
14094: AND ROWNUM = 1;
14095:
14096: l_incidental_worker Varchar2(1) := '0';
14097: