APPS.AP_WEB_PCARD_WORKFLOW_PKG dependencies on AP_CARDS_ALL

Line 35: ap_cards_all c,

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
39: fd.feed_line_id = fl.feed_line_id AND

Line 68: ap_cards_all c,

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
72: nvl(fl.create_distribution_flag,'N') = 'N' AND

Line 360: ap_cards_all c,

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
364: WHERE fd.status_lookup_code = 'VERIFIED'