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 PER_ASSIGNMENT_EXTRA_INFO

Line 350: from per_assignment_extra_info pae

346: CURSOR asg_provider
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

Line 494: from per_assignment_extra_info pae

490: CURSOR asg_provider
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

Line 724: from per_assignment_extra_info pae

720: CURSOR asg_provider
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

Line 1335: from per_assignment_extra_info pae

1331: CURSOR asg_provider
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