eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_WEB_PCARD_WORKFLOW_PKG dependencies on AP_CARDS

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 147: ap_cards c,

143: create_distribution_flag IS NULL)
144: AND employee_verification_id IS NULL
145: AND EXISTS (SELECT 'feed distribution falls in this workflow'
146: FROM ap_expense_feed_dists fd,
147: ap_cards c,
148: ap_card_profiles cp,
149: IBY_CREDITCARD IBY
150: WHERE fl.feed_line_id = fd.feed_line_id
151: AND c.card_reference_id=IBY.instrid

Line 173: ap_cards c,

169: WHERE status_lookup_code in ('VALIDATED', 'HOLD', 'REJECTED')
170: AND employee_verification_id IS NULL
171: AND EXISTS (SELECT 'feed distribution falls in this workflow'
172: FROM ap_expense_feed_lines fl,
173: ap_cards c,
174: ap_card_profiles cp,
175: IBY_CREDITCARD IBY
176: WHERE fl.feed_line_id = fd.feed_line_id
177: AND c.card_reference_id=IBY.instrid

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'

Line 454: ap_cards c,

450: WHERE status_lookup_code = 'VERIFIED'
451: AND manager_approval_id IS NULL
452: AND EXISTS (SELECT 'feed distribution falls in this workflow'
453: FROM ap_expense_feed_lines fl,
454: ap_cards c,
455: ap_card_profiles cp,
456: hr_employees_current_v hr,
457: IBY_CREDITCARD IBY
458: WHERE fl.feed_line_id = fd.feed_line_id

Line 924: ap_cards c,

920: WHERE employee_verification_id = l_emp_verification_id
921: AND status_lookup_code = 'VERIFIED'
922: AND exists (select 'no manager approval required'
923: from ap_expense_feed_lines fl,
924: ap_cards c,
925: ap_card_profiles cp,
926: IBY_CREDITCARD IBY
927: WHERE fl.feed_line_id = fd.feed_line_id
928: AND c.card_reference_id=IBY.instrid

Line 1059: ap_cards c,

1055: nvl(fl.posted_currency_code, cpr.card_program_currency_code),
1056: fd.description
1057: FROM ap_expense_feed_dists fd,
1058: ap_expense_feed_lines fl,
1059: ap_cards c,
1060: ap_card_profiles cp,
1061: ap_card_programs cpr,
1062: IBY_CREDITCARD IBY
1063: WHERE ((fd.employee_verification_id = l_emp_verification_id AND

Line 1439: ap_cards c,

1435: nvl(fl.posted_currency_code, cpr.card_program_currency_code),
1436: fd.description
1437: FROM ap_expense_feed_dists fd,
1438: ap_expense_feed_lines fl,
1439: ap_cards c,
1440: ap_card_profiles cp,
1441: ap_card_programs cpr,
1442: IBY_CREDITCARD IBY
1443: WHERE fd.manager_approval_id = l_manager_approval_id