[Home] [Help]
13: l_employee_id NUMBER;
14: l_status_lookup_code VARCHAR2(15);
15: l_employee_name wf_users.name%type; --8770726
16: l_employee_display_name wf_users.display_name%type; --8770726
17: l_employee_notification_method AP_CARD_PROFILES.emp_notification_lookup_code%TYPE;
18: l_new_emp_verification_id NUMBER;
19: l_num_records_updated NUMBER;
20: l_lines_without_dists_flag BOOLEAN := FALSE;
21: l_url VARCHAR2(1000);
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
40: fd.status_lookup_code =
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
73: fl.employee_verification_id IS NULL AND
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
152: AND fl.card_id = c.card_id
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
178: AND fl.card_id = c.card_id
338: l_employee_display_name wf_users.display_name%type; --Bug 10220928
339: l_manager_id NUMBER;
340: l_manager_name wf_users.name%type; --Bug 10220928
341: l_manager_display_name wf_users.display_name%type; --Bug 10220928
342: l_manager_approval_method AP_CARD_PROFILES.mgr_approval_lookup_code%TYPE;
343: l_new_manager_approval_id NUMBER;
344: l_url VARCHAR2(1000);
345: l_debug_info VARCHAR2(200);
346: l_records_undistributed_flag BOOLEAN := FALSE;
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'
365: AND fd.manager_approval_id IS NULL
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
459: AND c.card_reference_id=IBY.instrid
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
929: AND fl.card_id = c.card_id
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
1064: fd.feed_line_id = fl.feed_line_id) OR
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
1444: AND fd.feed_line_id = fl.feed_line_id