DBA Data[Home] [Help]

APPS.AP_WEB_PCARD_WORKFLOW_PKG dependencies on IBY_CREDITCARD

Line 37: IBY_CREDITCARD IBY

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
40: fd.status_lookup_code =
41: nvl(p_status_lookup_code,fd.status_lookup_code) AND

Line 70: IBY_CREDITCARD IBY

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
73: fl.employee_verification_id IS NULL AND
74: fd.feed_line_id(+) = fl.feed_line_id AND

Line 149: IBY_CREDITCARD IBY

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
152: AND fl.card_id = c.card_id
153: AND c.profile_id = cp.profile_id

Line 175: IBY_CREDITCARD IBY

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
178: AND fl.card_id = c.card_id
179: AND c.profile_id = cp.profile_id

Line 363: IBY_CREDITCARD IBY

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'
365: AND fd.manager_approval_id IS NULL
366: AND fd.feed_line_id = fl.feed_line_id
367: AND fl.card_id = c.card_id

Line 457: IBY_CREDITCARD IBY

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
459: AND c.card_reference_id=IBY.instrid
460: AND fl.card_id = c.card_id
461: AND c.profile_id = cp.profile_id

Line 926: IBY_CREDITCARD IBY

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
929: AND fl.card_id = c.card_id
930: AND c.profile_id = cp.profile_id

Line 1062: IBY_CREDITCARD IBY

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
1064: fd.feed_line_id = fl.feed_line_id) OR
1065: (fl.employee_verification_id = l_emp_verification_id))
1066: AND fl.card_id = c.card_id

Line 1442: IBY_CREDITCARD IBY

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
1444: AND fd.feed_line_id = fl.feed_line_id
1445: AND fl.card_id = c.card_id
1446: AND c.card_reference_id=IBY.instrid