DBA Data[Home] [Help]

APPS.PA_ADW_COLLECT_DIMENSIONS dependencies on PA_LOWEST_RLMEM_IT

Line 1519: PA_LOWEST_RLMEM_IT

1515: FOR lowest_res_members_r IN sel_lowest_res_members LOOP
1516:
1517: -- First Try to Update the Row in the Interface Table
1518: UPDATE
1519: PA_LOWEST_RLMEM_IT
1520: SET
1521: PARENT_MEMBER_ID = LOWEST_RES_MEMBERS_R.PARENT_MEMBER_ID,
1522: NAME = LOWEST_RES_MEMBERS_R.NAME,
1523: ALIAS = LOWEST_RES_MEMBERS_R.ALIAS,

Line 1551: INSERT INTO PA_LOWEST_RLMEM_IT

1547: -- Check If Any row was updated
1548:
1549: IF (SQL%ROWCOUNT = 0) THEN
1550: -- No row was updated, So Insert a new row into the interface table
1551: INSERT INTO PA_LOWEST_RLMEM_IT
1552: (
1553: RESOURCE_LIST_MEMBER_ID,
1554: PARENT_MEMBER_ID,
1555: NAME,