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.HR_NL_ORG_INFO dependencies on FND_SESSIONS

Line 80: ,fnd_sessions ses

76: --
77: CURSOR c_hierarchy_version(vp_organization_id NUMBER) IS
78: SELECT sv.org_structure_version_id, sv.version_number
79: FROM per_org_structure_versions sv
80: ,fnd_sessions ses
81: WHERE sv.organization_structure_id = named_hierarchy(vp_organization_id)
82: AND ses.session_id = USERENV('sessionid')
83: AND ses.effective_date BETWEEN sv.date_from
84: AND NVL(sv.date_to, Hr_general.End_Of_time)

Line 351: ,fnd_sessions s

347: (l_org_id in hr_organization_units.organization_id%type,l_si_type varchar2,l_assgn_id NUMBER) IS
348: select pae.aei_information8 provider,
349: decode(pae.aei_information3,'AMI',0,1) si_class_order
350: from per_assignment_extra_info pae
351: ,fnd_sessions s
352: where assignment_id = l_assgn_id
353: and (pae.aei_information3=decode (l_si_type,'WEWE','WW','WEWA','WW',
354: 'WAOB','WAO','WAOD','WAO','PRIVATE_HEALTH','ZFW',l_si_type) or
355: pae.AEI_INFORMATION3 = DECODE(l_si_type,'WEWA','AMI','WEWE','AMI','WAOD','AMI','WAOB','AMI',

Line 379: ,fnd_sessions s

375: e.org_information4 provider,nvl(e.org_information7,'N') p_flag,
376: decode(e.org_information3,'AMI',0,1) si_class_order
377: from
378: hr_organization_information e
379: ,fnd_sessions s
380: where
381: e.organization_id=l_org_id and
382: e.org_information_context = 'NL_SIP' and
383: (e.org_information3=DECODE(l_si_type,'WEWE','WW','WEWA','WW','WAOB','WAO','WAOD','WAO',

Line 495: ,fnd_sessions s

491: (l_org_id in hr_organization_units.organization_id%type,l_si_type varchar2,l_assgn_id NUMBER) IS
492: select pae.aei_information8 provider,
493: decode(pae.aei_information3,'AMI',0,1) si_class_order
494: from per_assignment_extra_info pae
495: ,fnd_sessions s
496: where assignment_id = l_assgn_id
497: and (pae.aei_information3=decode (l_si_type,'WEWE','WW','WEWA','WW',
498: 'WAOB','WAO','WAOD','WAO','PRIVATE_HEALTH','ZFW',l_si_type) or
499: pae.aei_information3 = DECODE(l_si_type,'WEWE','AMI','WEWA','AMI',

Line 521: ,fnd_sessions s

517: e.org_information4 provider,nvl(e.org_information7,'N') p_flag,
518: decode(e.org_information3,'AMI',0,1) si_class_order
519: from
520: hr_organization_information e
521: ,fnd_sessions s
522: where
523: e.organization_id=l_org_id and
524: e.org_information_context = 'NL_SIP' and
525: (e.org_information3=DECODE(l_si_type,'WEWE','WW','WEWA','WW','WAOB','WAO','WAOD','WAO',

Line 626: from per_all_assignments_f paa,fnd_sessions ses

622:
623: --Determine the Organization Id of the Employees Assignment
624: CURSOR get_org_id(p_assignment_id number) is
625: select paa.organization_id
626: from per_all_assignments_f paa,fnd_sessions ses
627: where paa.assignment_id = p_assignment_id and
628: ses.effective_date between paa.effective_start_date and paa.effective_end_date and
629: session_id = userenv('sessionid');
630:

Line 725: ,fnd_sessions s

721: (l_assgn_id NUMBER,l_si_type varchar2) IS
722: select pae.assignment_extra_info_id,
723: decode(pae.aei_information3,'AMI',0,1) si_class_order
724: from per_assignment_extra_info pae
725: ,fnd_sessions s
726: where assignment_id = l_assgn_id
727: and (pae.aei_information3=decode (l_si_type,'WEWE','WW','WEWA','WW',
728: 'WAOB','WAO','WAOD','WAO','PRIVATE_HEALTH','ZFW',l_si_type) or
729: pae.AEI_INFORMATION3 = DECODE(l_si_type,'WEWA','AMI','WEWE','AMI','WAOD','AMI','WAOB','AMI',

Line 756: from per_all_assignments_f paa,fnd_sessions ses

752: --Determine the Organization Id of the Employees Assignment
753: --
754: CURSOR get_org_id(p_assignment_id number) is
755: select paa.organization_id
756: from per_all_assignments_f paa,fnd_sessions ses
757: where paa.assignment_id = p_assignment_id and
758: ses.effective_date between paa.effective_start_date and paa.effective_end_date and
759: session_id = userenv('sessionid');
760:

Line 931: from per_all_assignments_f paa,fnd_sessions ses

927: --Determine the Organization Id of the Employees Assignment
928: --
929: CURSOR get_org_id(p_assignment_id number) is
930: select paa.organization_id
931: from per_all_assignments_f paa,fnd_sessions ses
932: where paa.assignment_id = p_assignment_id and
933: ses.effective_date between paa.effective_start_date and paa.effective_end_date and
934: session_id = userenv('sessionid');
935:

Line 1024: from per_all_assignments_f paa,fnd_sessions ses

1020: --Determine the Organization Id of the Employees Assignment
1021: --
1022: CURSOR get_org_id(p_assignment_id number) is
1023: select paa.organization_id
1024: from per_all_assignments_f paa,fnd_sessions ses
1025: where paa.assignment_id = p_assignment_id and
1026: ses.effective_date between paa.effective_start_date and paa.effective_end_date and
1027: session_id = userenv('sessionid');
1028:

Line 1121: from per_all_assignments_f paa,fnd_sessions ses

1117: --Determine the Organization Id of the Employees Assignment
1118: --
1119: CURSOR get_org_id(p_assignment_id number) is
1120: select paa.organization_id
1121: from per_all_assignments_f paa,fnd_sessions ses
1122: where paa.assignment_id = p_assignment_id and
1123: ses.effective_date between paa.effective_start_date and paa.effective_end_date and
1124: session_id = userenv('sessionid');
1125:

Line 1216: from per_all_assignments_f paa,fnd_sessions ses

1212: --Determine the Organization Id of the Employees Assignment
1213: --
1214: CURSOR get_org_id(p_assignment_id number) is
1215: select paa.organization_id
1216: from per_all_assignments_f paa,fnd_sessions ses
1217: where paa.assignment_id = p_assignment_id and
1218: ses.effective_date between paa.effective_start_date
1219: and paa.effective_end_date and
1220: session_id = userenv('sessionid');

Line 1336: ,fnd_sessions s

1332: (l_org_id in hr_organization_units.organization_id%type,l_si_type varchar2,l_assgn_id NUMBER) IS
1333: select pae.aei_information8 provider,
1334: decode(pae.aei_information3,'AMI',0,1) si_class_order
1335: from per_assignment_extra_info pae
1336: ,fnd_sessions s
1337: where assignment_id = l_assgn_id
1338: and (pae.aei_information3=decode (l_si_type,'WEWE','WW','WEWA','WW',
1339: 'WAOB','WAO','WAOD','WAO','PRIVATE_HEALTH','ZFW',l_si_type) or
1340: pae.aei_information3 = DECODE(l_si_type,'WEWE','AMI','WEWA','AMI',

Line 1362: ,fnd_sessions s

1358: e.org_information4 provider,nvl(e.org_information7,'N') p_flag,
1359: decode(e.org_information3,'AMI',0,1) si_class_order
1360: from
1361: hr_organization_information e
1362: ,fnd_sessions s
1363: where
1364: e.organization_id=l_org_id and
1365: e.org_information_context = 'NL_SIP' and
1366: (e.org_information3=DECODE(l_si_type,'WEWE','WW','WEWA','WW','WAOB','WAO','WAOD','WAO',

Line 1515: from per_all_assignments_f paa,fnd_sessions ses

1511: --Determine the Organization Id of the Employees Assignment
1512: --
1513: CURSOR get_org_id(p_assignment_id number) is
1514: select paa.organization_id
1515: from per_all_assignments_f paa,fnd_sessions ses
1516: where paa.assignment_id = p_assignment_id and
1517: ses.effective_date between paa.effective_start_date and paa.effective_end_date and
1518: session_id = userenv('sessionid');
1519:

Line 1982: from per_all_assignments_f paa,fnd_sessions ses

1978: -- Determine the Organization Id of the Employees Assignment
1979: --
1980: CURSOR get_org_id(p_assignment_id number) is
1981: select paa.organization_id
1982: from per_all_assignments_f paa,fnd_sessions ses
1983: where paa.assignment_id = p_assignment_id and
1984: ses.effective_date between paa.effective_start_date and paa.effective_end_date and
1985: session_id = userenv('sessionid');
1986: CURSOR csr_IZA_Weekly_Hours

Line 2071: from per_all_assignments_f paa,fnd_sessions ses

2067: -- Determine the Organization Id of the Employees Assignment
2068: --
2069: CURSOR get_org_id(p_assignment_id number) is
2070: select paa.organization_id
2071: from per_all_assignments_f paa,fnd_sessions ses
2072: where paa.assignment_id = p_assignment_id and
2073: ses.effective_date between paa.effective_start_date and paa.effective_end_date and
2074: session_id = userenv('sessionid');
2075: --

Line 2304: from per_all_assignments_f paa,fnd_sessions ses

2300:
2301: --Determine the Organization Id of the Employees Assignment
2302: CURSOR get_org_id(p_assignment_id number) is
2303: select paa.organization_id
2304: from per_all_assignments_f paa,fnd_sessions ses
2305: where paa.assignment_id = p_assignment_id and
2306: ses.effective_date between paa.effective_start_date and paa.effective_end_date and
2307: session_id = userenv('sessionid');
2308:

Line 2333: ,fnd_sessions ses

2329: --
2330: CURSOR csr_get_org_id(p_assignment_id NUMBER) IS
2331: SELECT paa.organization_id
2332: FROM per_all_assignments_f paa
2333: ,fnd_sessions ses
2334: WHERE paa.assignment_id = p_assignment_id
2335: AND ses.effective_date BETWEEN paa.effective_start_date
2336: AND paa.effective_end_date
2337: AND session_id = userenv ('sessionid');

Line 2421: ,fnd_sessions ses

2417:
2418: CURSOR csr_get_org_id(p_assignment_id IN number) IS
2419: SELECT paa.organization_id
2420: FROM per_all_assignments_f paa
2421: ,fnd_sessions ses
2422: WHERE paa.assignment_id = p_assignment_id
2423: AND ses.effective_date
2424: BETWEEN paa.effective_start_date
2425: AND paa.effective_end_date