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.POS_CHANGE_PROM_DATES dependencies on FND_PROFILE

Line 1474: FND_PROFILE.GET('RESP_ID', x_resp_id);

1470:
1471:
1472: BEGIN
1473:
1474: FND_PROFILE.GET('RESP_ID', x_resp_id);
1475:
1476: if x_resp_id is NULL then
1477:
1478: select MIN(fr.responsibility_id)

Line 1490: AND nvl(fnd_profile.value_specific('ORG_ID', NULL, fr.responsibility_id, fur.responsibility_application_id),-1) = nvl(x_org_id,-1)

1486: and fr.start_date < sysdate
1487: and nvl(fr.end_date, sysdate +1) >= sysdate
1488: and fur.start_date < sysdate
1489: and nvl(fur.end_date, sysdate +1) >= Sysdate
1490: AND nvl(fnd_profile.value_specific('ORG_ID', NULL, fr.responsibility_id, fur.responsibility_application_id),-1) = nvl(x_org_id,-1)
1491: and nvl(fsp.org_id,-1) = nvl(x_org_id,-1)
1492: and nvl(fsp.business_group_id,-1) = nvl(fnd_profile.value_specific('PER_BUSINESS_GROUP_ID', NULL, fr.responsibility_id, fur.responsibility_application_id),-1);
1493:
1494: end if;

Line 1492: and nvl(fsp.business_group_id,-1) = nvl(fnd_profile.value_specific('PER_BUSINESS_GROUP_ID', NULL, fr.responsibility_id, fur.responsibility_application_id),-1);

1488: and fur.start_date < sysdate
1489: and nvl(fur.end_date, sysdate +1) >= Sysdate
1490: AND nvl(fnd_profile.value_specific('ORG_ID', NULL, fr.responsibility_id, fur.responsibility_application_id),-1) = nvl(x_org_id,-1)
1491: and nvl(fsp.org_id,-1) = nvl(x_org_id,-1)
1492: and nvl(fsp.business_group_id,-1) = nvl(fnd_profile.value_specific('PER_BUSINESS_GROUP_ID', NULL, fr.responsibility_id, fur.responsibility_application_id),-1);
1493:
1494: end if;
1495:
1496: EXCEPTION