APPS.AMW_LOAD_SOD_DATA dependencies on FND_RESPONSIBILITY

Line 77: FROM FND_RESPONSIBILITY

73: WHERE batch_id = p_batch_id
74: AND cst_entries_resp_id IS NOT NULL
75: AND NOT EXISTS
76: ( SELECT 'Y'
77: FROM FND_RESPONSIBILITY
78: WHERE responsibility_id = cst_entries_resp_id
79: AND start_date <= sysdate
80: AND (end_date >= sysdate OR end_date IS NULL)
81: );

Line 751: Fnd_Responsibility_Vl to get the responsibility_id from responsibility_name

747: If the PK1 is Null, then it means that the responsibility_name in the
748: interface table is invalid.
749:
750: Populating of the Pk1 will avoid the joining of interface table with
751: Fnd_Responsibility_Vl to get the responsibility_id from responsibility_name
752: */
753: UPDATE amw_cst_waiver_interface acwi
754: SET acwi.pk1 = ( SELECT responsibility_id
755: FROM fnd_responsibility_vl resp

Line 755: FROM fnd_responsibility_vl resp

751: Fnd_Responsibility_Vl to get the responsibility_id from responsibility_name
752: */
753: UPDATE amw_cst_waiver_interface acwi
754: SET acwi.pk1 = ( SELECT responsibility_id
755: FROM fnd_responsibility_vl resp
756: WHERE resp.application_id = acwi.pk2
757: AND resp.responsibility_name = acwi.responsibility_name)
758: WHERE acwi.batch_id = p_batch_id
759: AND acwi.object_type = 'RESP'

Line 1121: Fnd_Responsibility_Vl to get the responsibility_id from responsibility_name

1117: If the PK1 is Null, then it means that the responsibility_name in the
1118: interface table is invalid.
1119:
1120: Populating of the Pk1 will avoid the joining of interface table with
1121: Fnd_Responsibility_Vl to get the responsibility_id from responsibility_name
1122: */
1123: UPDATE amw_cst_waiver_interface acwi
1124: SET acwi.pk1 = ( SELECT responsibility_id
1125: FROM fnd_responsibility_vl resp

Line 1125: FROM fnd_responsibility_vl resp

1121: Fnd_Responsibility_Vl to get the responsibility_id from responsibility_name
1122: */
1123: UPDATE amw_cst_waiver_interface acwi
1124: SET acwi.pk1 = ( SELECT responsibility_id
1125: FROM fnd_responsibility_vl resp
1126: WHERE resp.application_id = acwi.pk2
1127: AND resp.responsibility_name = acwi.responsibility_name)
1128: WHERE acwi.object_type = 'RESP'
1129: AND acwi.responsibility_name IS NOT NULL

Line 1457: FROM FND_RESPONSIBILITY resp

1453: AND av.STATUS_CODE <> 'NA'
1454: AND avu.USER_VIOLATION_ID=avue.USER_VIOLATION_ID
1455: AND avue.RESPONSIBILITY_ID IS NOT NULL
1456: AND 1 < ( SELECT COUNT(1)
1457: FROM FND_RESPONSIBILITY resp
1458: WHERE resp.START_DATE <= SYSDATE
1459: AND (resp.END_DATE >= SYSDATE or resp.END_DATE IS NULL)
1460: AND resp.RESPONSIBILITY_ID=avue.RESPONSIBILITY_ID);
1461:

Line 1477: FROM FND_RESPONSIBILITY resp

1473: AND (acv.END_DATE IS NULL OR acv.END_DATE>=SYSDATE)
1474: AND acv.CONSTRAINT_REV_ID=ace.CONSTRAINT_REV_ID
1475: AND ace.OBJECT_TYPE = 'RESP'
1476: AND 1 < ( SELECT COUNT(1)
1477: FROM FND_RESPONSIBILITY resp
1478: WHERE resp.START_DATE <= SYSDATE
1479: AND (resp.END_DATE >= SYSDATE or resp.END_DATE IS NULL)
1480: AND resp.RESPONSIBILITY_ID=ace.FUNCTION_ID)
1481: UNION ALL

Line 1549: FROM FND_RESPONSIBILITY resp

1545: AMW_CONSTRAINTs_VL acv
1546: WHERE acwb.CONSTRAINT_REV_ID =acv.CONSTRAINT_REV_ID
1547: AND acwb.OBJECT_TYPE='RESP'
1548: AND 1 < ( SELECT COUNT(1)
1549: FROM FND_RESPONSIBILITY resp
1550: WHERE resp.START_DATE <= SYSDATE
1551: AND (resp.END_DATE >= SYSDATE or resp.END_DATE IS NULL)
1552: AND resp.RESPONSIBILITY_ID=acwb.PK1);
1553:

Line 1588: FROM FND_RESPONSIBILITY_VL RESP,

1584: SELECT APPL.APPLICATION_ID,APPL.APPLICATION_NAME,RESP.RESPONSIBILITY_NAME
1585: BULK COLLECT INTO l_appl_id_list,
1586: l_appl_name_list,
1587: l_resp_name_list
1588: FROM FND_RESPONSIBILITY_VL RESP,
1589: FND_APPLICATION_VL APPL
1590: WHERE RESP.RESPONSIBILITY_ID = l_resp_id_list(i)
1591: AND RESP.START_DATE <= SYSDATE
1592: AND (RESP.END_DATE >= SYSDATE OR RESP.END_DATE IS NULL)

Line 1652: FROM FND_RESPONSIBILITY_VL RESP,

1648: SELECT APPL.APPLICATION_ID,APPL.APPLICATION_NAME,RESP.RESPONSIBILITY_NAME
1649: BULK COLLECT INTO l_appl_id_list,
1650: l_appl_name_list,
1651: l_resp_name_list
1652: FROM FND_RESPONSIBILITY_VL RESP,
1653: FND_APPLICATION_VL APPL
1654: WHERE RESP.RESPONSIBILITY_ID = l_function_id_list(i)
1655: AND RESP.START_DATE <= SYSDATE
1656: AND (RESP.END_DATE >= SYSDATE OR RESP.END_DATE IS NULL)

Line 1863: FROM FND_RESPONSIBILITY_VL RESP,

1859: SELECT APPL.APPLICATION_ID,APPL.APPLICATION_NAME,RESP.RESPONSIBILITY_NAME
1860: BULK COLLECT INTO l_appl_id_list,
1861: l_appl_name_list,
1862: l_resp_name_list
1863: FROM FND_RESPONSIBILITY_VL RESP,
1864: FND_APPLICATION_VL APPL
1865: WHERE RESP.RESPONSIBILITY_ID = l_resp_id_list(i)
1866: AND RESP.START_DATE <= SYSDATE
1867: AND (RESP.END_DATE >= SYSDATE OR RESP.END_DATE IS NULL)