APPS.AS_GAR_ACCOUNTS_PUB dependencies on AS_TERR_RESOURCES_TMP

Line 20: -- salesforce_role_code into as_accesses_all table by fetching it from as_terr_resources_tmp table. fix for bug (5869095)

16: -- 3: Soft Delete unwanted records from AS_ACCESSES_ALL_ALL
17: --
18: -- NOTE: No Owner Assignment and Cleanup steps required for Accounts
19: -- 3-5-2007 annsrini included 2 cursors c_src and ins_acc. Also modified ins_acc2 cursor and INSERT_ACCESS_ACCOUNTS procedure to populate
20: -- salesforce_role_code into as_accesses_all table by fetching it from as_terr_resources_tmp table. fix for bug (5869095)
21: ---------------------------------------------------------------------------
22: /*-------------------------------------------------------------------------+
23: | PRIVATE CONSTANTS
24: +-------------------------------------------------------------------------*/

Line 997: AS_TERR_RESOURCES_TMP ATR

993: W.RESOURCE_TYPE,
994: ORG_ID,
995: ATR.RESOURCE_TYPE SALESFORCE_ROLE_CODE
996: FROM JTF_TAE_1001_ACCOUNT_WINNERS W,
997: AS_TERR_RESOURCES_TMP ATR
998: WHERE W.SOURCE_ID = -1001
999: AND W.worker_id = c_worker_id
1000: AND W.RESOURCE_TYPE = 'RS_EMPLOYEE'
1001: AND W.PERSON_ID=ATR.RESOURCE_ID(+)