APPS.AP_WEB_POLICY_UTILS dependencies on AP_POL_CONTEXT

Line 523: FROM AP_POL_CONTEXT

519: l_count NUMBER;
520: BEGIN
521: SELECT count(1)
522: INTO l_count
523: FROM AP_POL_CONTEXT
524: WHERE user_id = p_user_id;
525:
526: /*-----------------------------------------------------------------*
527: | The query should never return 0, however if 0 is returned it is |

Line 572: AP_POL_CONTEXT pc

568: pco.ORG_ID,
569: pc.user_id,
570: pc.selected_org_id
571: FROM AP_POL_CAT_OPTIONS_ALL pco,
572: AP_POL_CONTEXT pc
573: WHERE pco.org_id(+) = pc.selected_org_id
574: AND pco.category_code(+) = p_category_code
575: AND pc.user_id = p_user_id;
576:

Line 1162: AP_POL_CONTEXT pc

1158: ex.ORG_ID,
1159: pc.user_id,
1160: pc.selected_org_id
1161: FROM AP_POL_EXRATE_OPTIONS_ALL ex,
1162: AP_POL_CONTEXT pc
1163: WHERE ex.org_id(+) = pc.selected_org_id
1164: AND pc.user_id = p_user_id;
1165:
1166: BEGIN

Line 4628: AP_POL_CONTEXT pc

4624: SELECT ep.ORG_ID,
4625: pc.user_id,
4626: pc.selected_org_id
4627: FROM AP_EXPENSE_PARAMS_ALL ep,
4628: AP_POL_CONTEXT pc
4629: WHERE ep.org_id(+) = pc.selected_org_id
4630: AND pc.user_id = p_user_id;
4631:
4632: BEGIN