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.AS_SALES_ORG_MANAGER_PVT dependencies on DUAL

Line 688: and rrel.role_resource_type = 'RS_INDIVIDUAL'

684: Where force.user_id = fnd_user.user_id
685: and fnd_user.user_id = p_user_id
686: and force.category in ('EMPLOYEE','PARTY')
687: and force.resource_id = rrel.role_resource_id
688: and rrel.role_resource_type = 'RS_INDIVIDUAL'
689: and rrel.role_id = roleb.role_id
690: and roleb.role_type_code in ('SALES','TELESALES','FIELDSALES','PRM')
691: and rownum = 1;
692:

Line 709: from dual

705: and rownum = 1;
706:
707: Cursor C_GetAdminGroup(p_salesforce_id NUMBER, p_sales_group_id NUMBER) IS
708: Select 1
709: from dual
710: where exists(select 1 from AS_FC_SALESFORCE_V force
711: where salesforce_id = p_salesforce_id
712: and sales_group_id = p_sales_group_id);
713:

Line 955: from dual

951: l_rec_count Number := 1;
952:
953: Cursor C_GetGroupExist(p_salesforce_id NUMBER) IS
954: select 1
955: from dual
956: where exists(select 1 from AS_FC_SALESFORCE_V sale
957: where sale.salesforce_id = p_salesforce_id);
958:
959: l_found NUMBER;