APPS.AP_WEB_PCARD_WORKFLOW_PKG dependencies on AP_EXPENSE_FEED_DISTS_ALL

Line 34: ap_expense_feed_dists_all fd,

30: decode(cp.emp_notification_lookup_code, 'N', null, fl.employee_id),
31: decode(cp.emp_notification_lookup_code, 'Y',
32: fd.status_lookup_code, null)
33: FROM ap_expense_feed_lines fl,
34: ap_expense_feed_dists_all fd,
35: ap_cards_all c,
36: ap_card_profiles_all cp,
37: IBY_CREDITCARD IBY
38: WHERE fl.create_distribution_flag = 'Y' AND

Line 67: ap_expense_feed_dists_all fd,

63: decode(cp.emp_notification_lookup_code, 'N', null, fl.employee_id),
64: decode(cp.emp_notification_lookup_code, 'Y',
65: fd.status_lookup_code, null)
66: FROM ap_expense_feed_lines fl,
67: ap_expense_feed_dists_all fd,
68: ap_cards_all c,
69: ap_card_profiles_all cp,
70: IBY_CREDITCARD IBY
71: WHERE

Line 359: ap_expense_feed_dists_all fd,

355: SELECT cp.mgr_approval_lookup_code,
356: decode(cp.mgr_approval_lookup_code, 'N', null, hr.supervisor_id),
357: decode(cp.mgr_approval_lookup_code, 'N', null, fl.employee_id)
358: FROM ap_expense_feed_lines fl,
359: ap_expense_feed_dists_all fd,
360: ap_cards_all c,
361: ap_card_profiles_all cp,
362: per_employees_x hr,
363: IBY_CREDITCARD IBY

Line 729: ap_expense_feed_dists_all fd

725: BEGIN
726: SELECT distinct(nvl(fl.org_id,fd.org_id))
727: INTO l_org_id
728: FROM ap_expense_feed_lines_all fl,
729: ap_expense_feed_dists_all fd
730: WHERE fl.employee_verification_id = p_employee_verification_id
731: OR (fd.feed_line_id = fl.feed_line_id AND
732: fd.employee_verification_id = p_employee_verification_id);
733: if (l_org_id is not null) then

Line 755: FROM ap_expense_feed_dists_all fd

751: BEGIN
752:
753: SELECT distinct(org_id)
754: INTO l_org_id
755: FROM ap_expense_feed_dists_all fd
756: WHERE fd.manager_approval_id = p_manager_approval_id;
757:
758: if (l_org_id is not null) then
759: Mo_Global.set_policy_context('S', l_org_id);