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 2744: AND Nvl(date_to,Hr_Api.g_eot)

2740: hr_organization_information hoi
2741: WHERE hoi.organization_id = p_business_group_id
2742: AND To_Number(hoi.org_information1) = pos.organization_structure_id
2743: AND Trunc(p_effective_date) BETWEEN date_from
2744: AND Nvl(date_to,Hr_Api.g_eot)
2745: AND hoi.org_information_context = 'NL_BG_INFO';
2746:
2747: --Cursor to fetch immediate children of org
2748: CURSOR csr_get_children(c_org_id hr_all_organization_units.organization_id%TYPE,

Line 3498: l_date date := hr_api.g_eot;

3494: l_amount NUMBER;
3495: l_context_id NUMBER;
3496: l_si_type varchar2(4);
3497: l_code NUMBER;
3498: l_date date := hr_api.g_eot;
3499: l_new_start date;
3500: l_old_start date;
3501: l_new_start_can ben_ext_chg_evt_log.new_val1%TYPE;
3502: l_old_start_can ben_ext_chg_evt_log.old_val1%TYPE;

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

5721: hr_organization_information hoi
5722: WHERE hoi.organization_id = p_business_group_id
5723: AND To_Number(hoi.org_information1) = pos.organization_structure_id
5724: AND Trunc(p_effective_date) BETWEEN date_from
5725: AND Nvl(date_to,Hr_Api.g_eot)
5726: AND hoi.org_information_context = 'NL_BG_INFO';
5727: --
5728: -- Cursor to get the list of orgs from the hierarchy if one exists.
5729: --

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

6868: SELECT org_structure_version_id
6869: FROM per_org_structure_versions_v
6870: WHERE organization_structure_id = c_hierarchy_id
6871: AND g_extract_params(p_business_group_id).extract_end_date BETWEEN date_from
6872: AND nvl(date_to,hr_api.g_eot);
6873:
6874: --
6875: -- Cursor to find the valid version id for a particular business group
6876: --

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

6878: SELECT org_structure_version_id
6879: FROM per_org_structure_versions_v
6880: WHERE business_group_id = p_business_group_id
6881: AND g_extract_params(p_business_group_id).extract_end_date BETWEEN date_from
6882: AND nvl( date_to,hr_api.g_eot);
6883: --
6884: -- Cursor to find the parent id from the org id
6885: --
6886: CURSOR c_find_parent_id(c_org_id in number

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

7203: SELECT region_1
7204: FROM per_addresses_v
7205: WHERE person_id = c_person_id
7206: AND p_effective_date BETWEEN date_from
7207: AND Nvl(date_to,Hr_Api.g_eot)
7208: AND primary_flag = 'Y'
7209: AND style = 'NL'
7210: UNION
7211: SELECT address_line1

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

7211: SELECT address_line1
7212: FROM per_addresses_v
7213: WHERE person_id = c_person_id
7214: AND p_effective_date BETWEEN date_from
7215: AND Nvl(date_to,Hr_Api.g_eot)
7216: AND primary_flag = 'Y'
7217: AND style = 'NL_GLB';
7218:
7219: l_street per_addresses_v.region_1%TYPE;

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

7253: SELECT add_information13
7254: FROM per_addresses_v
7255: WHERE person_id = c_person_id
7256: AND p_effective_date BETWEEN date_from
7257: AND Nvl(date_to,Hr_Api.g_eot)
7258: AND style = 'NL'
7259: AND primary_flag = 'Y'
7260: UNION
7261: SELECT address_line2

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

7261: SELECT address_line2
7262: FROM per_addresses_v
7263: WHERE person_id = c_person_id
7264: AND p_effective_date BETWEEN date_from
7265: AND Nvl(date_to,Hr_Api.g_eot)
7266: AND style = 'NL_GLB'
7267: AND primary_flag = 'Y';
7268:
7269: l_house_num per_addresses_v.address_line1%TYPE;

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

7308: SELECT add_information14
7309: FROM per_addresses_v
7310: WHERE person_id = c_person_id
7311: AND p_effective_date BETWEEN date_from
7312: AND Nvl(date_to,Hr_Api.g_eot)
7313: AND primary_flag = 'Y'
7314: AND style = 'NL'
7315: UNION
7316: SELECT address_line3

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

7316: SELECT address_line3
7317: FROM per_addresses_v
7318: WHERE person_id = c_person_id
7319: AND p_effective_date BETWEEN date_from
7320: AND Nvl(date_to,Hr_Api.g_eot)
7321: AND primary_flag = 'Y'
7322: AND style = 'NL_GLB';
7323:
7324: l_addl_house_num per_addresses_v.address_line1%TYPE;

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

7363: SELECT postal_code
7364: FROM per_addresses_v
7365: WHERE person_id = c_person_id
7366: AND p_effective_date BETWEEN date_from
7367: AND Nvl(date_to,Hr_Api.g_eot)
7368: AND style IN ('NL','NL_GLB')
7369: AND primary_flag = 'Y';
7370:
7371: l_postal_code per_addresses_v.postal_code%TYPE;

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

7423: SELECT town_or_city
7424: FROM per_addresses_v
7425: WHERE person_id = c_person_id
7426: AND p_effective_date BETWEEN date_from
7427: AND Nvl(date_to,Hr_Api.g_eot)
7428: AND style IN ('NL','NL_GLB')
7429: AND primary_flag = 'Y';
7430:
7431: CURSOR cur_get_foreign_coun(c_person_id IN Number) IS

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

7433: ,d_country
7434: FROM per_addresses_v
7435: WHERE person_id = c_person_id
7436: AND p_effective_date BETWEEN date_from
7437: AND Nvl(date_to,Hr_Api.g_eot)
7438: AND style IN ('NL','NL_GLB')
7439: AND primary_flag = 'Y';
7440:
7441:

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

7506: SELECT Decode(country,'NL',' ','J')
7507: FROM per_addresses_v
7508: WHERE person_id = c_person_id
7509: AND p_effective_date BETWEEN date_from
7510: AND Nvl(date_to,Hr_Api.g_eot)
7511: AND style IN ('NL','NL_GLB')
7512: AND primary_flag = 'Y';
7513:
7514: l_country per_addresses_v.d_country%TYPE;

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

7566: SELECT DECODE(country,'NL','N','J')
7567: FROM per_addresses_v
7568: WHERE person_id = c_person_id
7569: AND p_effective_date BETWEEN date_from
7570: AND NVL(date_to,hr_api.g_eot)
7571: AND style IN('NL','NL_GLB')
7572: AND primary_flag = 'Y';
7573:
7574: l_marital_status per_all_people_f.marital_status%TYPE;

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

7628: AND information_type = 'NL_ABP_PAR_INFO'
7629: AND aei_information_category = 'NL_ABP_PAR_INFO'
7630: AND p_effective_date BETWEEN
7631: TRUNC(fnd_date.canonical_to_date(aei_information1))
7632: AND TRUNC(NVL(fnd_date.canonical_to_date(aei_information2),hr_api.g_eot))
7633: AND aei_information6 IS NOT NULL;
7634:
7635: l_ret_val NUMBER := 0;
7636: l_asg_action_id pay_assignment_actions.assignment_action_id%TYPE;

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

8274: SELECT contact_person_id
8275: FROM per_contact_relationships
8276: WHERE person_id = g_person_id
8277: AND p_effective_date BETWEEN date_start
8278: AND Nvl(date_end,Hr_Api.g_eot)
8279: AND contact_type IN ('S','D')
8280: AND business_group_id = p_business_group_id;
8281:
8282: --

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

8475: SELECT DECODE(country,'NL','N','J')
8476: FROM per_addresses_v
8477: WHERE person_id = c_person_id
8478: AND p_effective_date BETWEEN date_from
8479: AND NVL(date_to,hr_api.g_eot)
8480: AND style IN('NL','NL_GLB')
8481: AND primary_flag = 'Y';
8482:
8483: --

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

8518: SELECT 1
8519: FROM per_addresses_v padr
8520: WHERE person_id = c_person_id
8521: -- if the current primary address is not in NL
8522: AND p_effective_date BETWEEN date_from AND NVL(date_to,hr_api.g_eot)
8523: AND primary_flag = 'Y'
8524: AND country <> 'NL'
8525: AND EXISTS (SELECT 1
8526: -- exists change in address event logs

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

8543: SELECT 1
8544: FROM per_addresses_v padr
8545: WHERE person_id = c_person_id
8546: -- if the current primary address is in NL
8547: AND p_effective_date BETWEEN date_from AND NVL(date_to,hr_api.g_eot)
8548: AND primary_flag = 'Y'
8549: AND country = 'NL'
8550: AND EXISTS (SELECT 1
8551: -- exists change in address event logs

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

8588: ,c_addr_id IN NUMBER) IS
8589: SELECT 1
8590: FROM per_addresses_v padr
8591: WHERE person_id = g_person_id
8592: AND p_effective_date BETWEEN date_from AND NVL(date_to,hr_api.g_eot)
8593: AND address_id = c_addr_id
8594: AND primary_flag = 'Y'
8595: AND country = c_code;
8596:

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

9358: SELECT ORG_STRUCTURE_VERSION_ID
9359: FROM per_org_structure_versions_v
9360: WHERE organization_structure_id = c_hierarchy_id
9361: AND p_effective_date BETWEEN date_from
9362: AND Nvl(date_to,Hr_Api.g_eot);
9363:
9364: --Cursor to find the valid version id for a particular business group
9365: CURSOR c_find_ver_frm_bg IS
9366: SELECT ORG_STRUCTURE_VERSION_ID

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

9366: SELECT ORG_STRUCTURE_VERSION_ID
9367: FROM per_org_structure_versions_v
9368: WHERE business_group_id = p_business_group_id
9369: AND p_effective_date BETWEEN date_from
9370: AND Nvl( date_to,Hr_Api.g_eot);
9371:
9372: --Cursor to find the parent id from the org id
9373: CURSOR c_find_parent_id(c_org_id IN Number
9374: ,c_version_id IN Number) IS

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

9669: SELECT ORG_STRUCTURE_VERSION_ID
9670: FROM per_org_structure_versions_v
9671: WHERE organization_structure_id = c_hierarchy_id
9672: AND p_date_earned BETWEEN date_from
9673: AND Nvl(date_to,Hr_Api.g_eot);
9674:
9675: --Cursor to find the valid version id for a particular business group
9676: CURSOR c_find_ver_frm_bg IS
9677: SELECT ORG_STRUCTURE_VERSION_ID

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

9677: SELECT ORG_STRUCTURE_VERSION_ID
9678: FROM per_org_structure_versions_v
9679: WHERE business_group_id = p_business_group_id
9680: AND p_date_earned BETWEEN date_from
9681: AND Nvl( date_to,Hr_Api.g_eot);
9682:
9683: --Cursor to find the parent id from the org id
9684: CURSOR c_find_parent_id(c_org_id IN Number
9685: ,c_version_id IN Number) IS

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

9700: AND hoi.organization_id = c_org_id;
9701:
9702: --Cursor to find the participation end date from org level information
9703: CURSOR c_get_org_info(c_org_id IN hr_organization_information.organization_id%TYPE) IS
9704: SELECT Fnd_Date.canonical_to_date(Nvl(hoi.org_information2,Fnd_Date.date_to_canonical(Hr_Api.g_eot)))
9705: FROM hr_organization_information hoi
9706: WHERE hoi.org_information_context = 'PQP_NL_ABP_PT'
9707: AND hoi.org_information3 = To_Char(p_pension_type_id)
9708: AND hoi.org_information6 = 'Y'

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

9708: AND hoi.org_information6 = 'Y'
9709: AND NVL(hoi.org_information7,'Y') = 'Y'
9710: AND hoi.organization_id = c_org_id
9711: AND p_date_earned BETWEEN Fnd_Date.canonical_to_date(hoi.org_information1)
9712: AND Fnd_Date.canonical_to_date(Nvl(hoi.org_information2,Fnd_Date.date_to_canonical(Hr_Api.g_eot)));
9713:
9714: BEGIN
9715: -- find the org the assignment is attached to
9716: OPEN c_find_org_id;

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

9884: SELECT ORG_STRUCTURE_VERSION_ID
9885: FROM per_org_structure_versions_v
9886: WHERE organization_structure_id = c_hierarchy_id
9887: AND p_effective_date BETWEEN date_from
9888: AND Nvl(date_to,Hr_Api.g_eot);
9889:
9890: --Cursor to find the valid version id for a particular business group
9891: CURSOR c_find_ver_frm_bg IS
9892: SELECT ORG_STRUCTURE_VERSION_ID

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

9892: SELECT ORG_STRUCTURE_VERSION_ID
9893: FROM per_org_structure_versions_v
9894: WHERE business_group_id = p_business_group_id
9895: AND p_effective_date BETWEEN date_from
9896: AND Nvl( date_to,Hr_Api.g_eot);
9897:
9898: --Cursor to find the parent id from the org id
9899: CURSOR c_find_parent_id(c_org_id IN Number
9900: ,c_version_id IN Number) IS

Line 10157: IF l_end_date = hr_api.g_eot THEN

10153: ,p_date_earned => p_effective_date
10154: ,p_end_date => l_end_date
10155: );
10156: IF l_ret_val = 0 THEN
10157: IF l_end_date = hr_api.g_eot THEN
10158: g_fur_dates(i).new_end := '';
10159: ELSE
10160: g_fur_dates(i).new_end := Fnd_Date.date_to_canonical(l_end_date) ;
10161: END IF;

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

10262: AND p_effective_date BETWEEN pty.effective_start_date and pty.effective_end_date
10263: AND pty.pension_sub_category IN ('PPP')
10264: AND p_effective_date between fnd_date.canonical_to_date(paei.aei_information1)
10265: AND fnd_date.canonical_to_date(NVL(paei.aei_information2,
10266: fnd_date.date_to_canonical(hr_api.g_eot)));
10267:
10268: /* Cursor changed for 6670714
10269: CURSOR c_rr_cur IS
10270: SELECT 1

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

10306: AND ( NVL(hoi1.org_information6,'N')= 'N'
10307: OR NVL(hoi1.org_information7,'N')= 'N')
10308: AND p_effective_date BETWEEN fnd_date.canonical_to_date(hoi1.org_information1)
10309: AND fnd_date.canonical_to_date(NVL(hoi1.org_information2,
10310: fnd_date.date_to_canonical(hr_api.g_eot))))
10311: ))
10312: AND hoi.org_information_context = 'PQP_NL_ABP_PT'
10313: AND hoi.org_information3 = TO_CHAR(pty.pension_type_id)
10314: AND p_effective_date BETWEEN pty.effective_start_date AND pty.effective_end_date

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

10316: AND NVL(hoi.org_information6,'N') = 'Y'
10317: AND NVL(hoi.org_information7,'N') = 'Y'
10318: AND p_effective_date BETWEEN fnd_date.canonical_to_date(hoi.org_information1)
10319: AND fnd_date.canonical_to_date(NVL(hoi.org_information2,
10320: fnd_date.date_to_canonical(hr_api.g_eot)));
10321:
10322:
10323: BEGIN
10324: Hr_Utility.set_location('Entering ------ : '||l_proc_name,10);

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

10458: AND ( NVL(hoi1.org_information6,'N')= 'N'
10459: OR NVL(hoi1.org_information7,'N')= 'N')
10460: AND p_effective_date BETWEEN fnd_date.canonical_to_date(hoi1.org_information1)
10461: AND fnd_date.canonical_to_date(NVL(hoi1.org_information2,
10462: fnd_date.date_to_canonical(hr_api.g_eot))))
10463: ))
10464: AND hoi.org_information_context = 'PQP_NL_ABP_PT'
10465: AND hoi.org_information3 = TO_CHAR(pty.pension_type_id)
10466: AND p_effective_date BETWEEN pty.effective_start_date AND pty.effective_end_date

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

10472: AND NVL(hoi.org_information6,'N') = 'Y'
10473: AND NVL(hoi.org_information7,'N') = 'Y'
10474: AND p_effective_date BETWEEN fnd_date.canonical_to_date(hoi.org_information1)
10475: AND fnd_date.canonical_to_date(NVL(hoi.org_information2,
10476: fnd_date.date_to_canonical(hr_api.g_eot)))
10477: AND NOT EXISTS (SELECT 1
10478: FROM per_assignment_extra_info paei1
10479: WHERE paei1.information_type='NL_ABP_RI'
10480: AND paei1.aei_information_category='NL_ABP_RI'

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

10481: AND paei1.assignment_id = p_assignment_id
10482: AND paei1.aei_information3 = 'G'
10483: AND p_effective_date BETWEEN fnd_date.canonical_to_date(paei1.aei_information1)
10484: AND fnd_date.canonical_to_date(NVL(paei1.aei_information2,
10485: fnd_date.date_to_canonical(hr_api.g_eot))));
10486:
10487: CURSOR c_fpu_asg IS
10488: SELECT DISTINCT DECODE (pty.pension_sub_category,'FPU_B','S'
10489: ,'FPU_C','S'

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

10504: 'FPU_S',
10505: 'FPU_T')
10506: AND p_effective_date between fnd_date.canonical_to_date(paei.aei_information1)
10507: AND fnd_date.canonical_to_date(NVL(paei.aei_information2,
10508: fnd_date.date_to_canonical(hr_api.g_eot)))
10509: AND NOT EXISTS (SELECT 1
10510: FROM per_assignment_extra_info paei1
10511: WHERE paei1.information_type='NL_ABP_RI'
10512: AND paei1.aei_information_category='NL_ABP_RI'

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

10513: AND paei1.assignment_id = p_assignment_id
10514: AND paei1.aei_information3 = 'G'
10515: AND p_effective_date BETWEEN fnd_date.canonical_to_date(paei1.aei_information1)
10516: AND fnd_date.canonical_to_date(NVL(paei1.aei_information2,
10517: fnd_date.date_to_canonical(hr_api.g_eot))));
10518:
10519: BEGIN
10520:
10521: Hr_Utility.set_location('Entering ------ : '||l_proc_name,5);

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

10575: SELECT Substr(Nvl(aei_information4,'G'),0,1)
10576: FROM per_assignment_extra_info
10577: WHERE assignment_id = p_assignment_id
10578: AND p_effective_date BETWEEN Fnd_Date.canonical_to_date(aei_information1)
10579: AND Fnd_Date.canonical_to_date(Nvl(aei_information2,Fnd_Date.date_to_canonical(Hr_Api.g_eot)))
10580: AND aei_information_category = 'NL_ABP_RI'
10581: AND information_type = 'NL_ABP_RI';
10582:
10583: BEGIN

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

10993: WHERE information_type = 'NL_ABP_PAR_INFO'
10994: AND aei_information_category = 'NL_ABP_PAR_INFO'
10995: AND assignment_id = p_assignment_id
10996: AND p_effective_date BETWEEN Fnd_Date.canonical_to_date(aei_information1)
10997: AND Fnd_Date.canonical_to_date(Nvl(aei_information2,Fnd_Date.date_to_canonical(Hr_Api.g_eot)));
10998: --
10999: -- Cursor to get the hire date of the person
11000: --
11001: CURSOR c_hire_dt IS

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

12274: SELECT ORG_STRUCTURE_VERSION_ID
12275: FROM per_org_structure_versions_v
12276: WHERE organization_structure_id = c_hierarchy_id
12277: AND p_effective_date BETWEEN date_from
12278: AND Nvl(date_to,Hr_Api.g_eot);
12279:
12280: --Cursor to find the valid version id for a particular business group
12281: CURSOR c_find_ver_frm_bg IS
12282: SELECT ORG_STRUCTURE_VERSION_ID

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

12282: SELECT ORG_STRUCTURE_VERSION_ID
12283: FROM per_org_structure_versions_v
12284: WHERE business_group_id = p_business_group_id
12285: AND p_effective_date BETWEEN date_from
12286: AND Nvl( date_to,Hr_Api.g_eot);
12287:
12288: --Cursor to find the parent id from the org id
12289: CURSOR c_find_parent_id(c_org_id IN Number
12290: ,c_version_id IN Number) IS

Line 12545: IF l_end_date = hr_api.g_eot THEN

12541: ,p_date_earned => p_effective_date
12542: ,p_end_date => l_end_date
12543: );
12544: IF l_ret_val = 0 THEN
12545: IF l_end_date = hr_api.g_eot THEN
12546: g_ipap_dates(i).new_end := '';
12547: ELSE
12548: g_ipap_dates(i).new_end := Fnd_Date.date_to_canonical(l_end_date) ;
12549: END IF;

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

12850: AND aei_information_category = 'NL_ABP_PAR_INFO'
12851: AND information_type = 'NL_ABP_PAR_INFO'
12852: AND trunc(c_nh_date) BETWEEN fnd_date.canonical_to_date(aei_information1)
12853: AND fnd_date.canonical_to_date(nvl(aei_information2,
12854: fnd_date.date_to_canonical(hr_api.g_eot)))
12855: AND aei_information6 IS NOT NULL;
12856:
12857: CURSOR c_get_override_salary (c_start IN DATE, c_end IN DATE) IS
12858: SELECT fnd_number.canonical_to_number(nvl(new_val1,'0'))

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

14324: SELECT Substr(Nvl(aei_information7,'D'),0,1)
14325: FROM per_assignment_extra_info
14326: WHERE assignment_id = p_assignment_id
14327: AND p_effective_date BETWEEN Fnd_Date.canonical_to_date(aei_information1)
14328: AND Fnd_Date.canonical_to_date(Nvl(aei_information2,Fnd_Date.date_to_canonical(Hr_Api.g_eot)))
14329: AND aei_information_category = 'NL_ABP_RI'
14330: AND information_type = 'NL_ABP_RI';
14331:
14332: BEGIN

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

14407: WHERE assignment_id = p_assignment_id
14408: AND aei_information_category = 'NL_ABP_RI'
14409: AND information_type = 'NL_ABP_RI'
14410: AND p_effective_date BETWEEN Fnd_Date.canonical_to_date(aei_information1)
14411: AND Fnd_Date.canonical_to_date(Nvl(aei_information2,Fnd_Date.date_to_canonical(Hr_Api.g_eot)));
14412:
14413: l_proc_name Varchar2(30) := 'Get_Ins_Typ_Anw_Ipap';
14414: l_anw_type Varchar2(2) := '01';
14415: l_ipap_type Varchar2(2) := '01';

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

14458: WHERE information_type = 'NL_USZO_INFO'
14459: AND aei_information_category = 'NL_USZO_INFO'
14460: AND assignment_id = p_assignment_id
14461: AND p_effective_date BETWEEN Fnd_Date.canonical_to_date(aei_information1)
14462: AND Fnd_Date.canonical_to_date(Nvl(aei_information2,Fnd_Date.date_to_canonical(Hr_Api.g_eot)))
14463: AND ROWNUM = 1;
14464:
14465: l_incidental_worker Varchar2(1) := '0';
14466: