APPS.AP_WEB_POLICY_UTILS dependencies on AP_POL_CONTEXT

Line 534: FROM AP_POL_CONTEXT

530: l_count NUMBER;
531: BEGIN
532: SELECT count(1)
533: INTO l_count
534: FROM AP_POL_CONTEXT
535: WHERE user_id = p_user_id;
536:
537: /*-----------------------------------------------------------------*
538: | The query should never return 0, however if 0 is returned it is |

Line 583: AP_POL_CONTEXT pc

579: pco.ORG_ID,
580: pc.user_id,
581: pc.selected_org_id
582: FROM AP_POL_CAT_OPTIONS_ALL pco,
583: AP_POL_CONTEXT pc
584: WHERE pco.org_id(+) = pc.selected_org_id
585: AND pco.category_code(+) = p_category_code
586: AND pc.user_id = p_user_id;
587:

Line 1187: AP_POL_CONTEXT pc

1183: ex.ORG_ID,
1184: pc.user_id,
1185: pc.selected_org_id
1186: FROM AP_POL_EXRATE_OPTIONS_ALL ex,
1187: AP_POL_CONTEXT pc
1188: WHERE ex.org_id(+) = pc.selected_org_id
1189: AND pc.user_id = p_user_id;
1190:
1191: BEGIN

Line 4699: AP_POL_CONTEXT pc

4695: SELECT ep.ORG_ID,
4696: pc.user_id,
4697: pc.selected_org_id
4698: FROM AP_EXPENSE_PARAMS_ALL ep,
4699: AP_POL_CONTEXT pc
4700: WHERE ep.org_id(+) = pc.selected_org_id
4701: AND pc.user_id = p_user_id;
4702:
4703: BEGIN