[Home] [Help]
29: 'N', 'I', cp.emp_notification_lookup_code),
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
62: 'N', 'I', cp.emp_notification_lookup_code),
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
136: ------------------------------------------------------------------------
137: --bug5058949
138: --Performance fix
139:
140: UPDATE ap_expense_feed_lines fl
141: SET employee_verification_id = l_new_emp_verification_id
142: WHERE (create_distribution_flag = 'N' OR
143: create_distribution_flag IS NULL)
144: AND employee_verification_id IS NULL
168: SET employee_verification_id = l_new_emp_verification_id
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
186: l_debug_info := 'Make sure records where updated with this verification_id';
187: --------------------------------------------------------------------
188: SELECT count(*)
189: INTO l_num_records_updated
190: FROM ap_expense_feed_lines fl,
191: ap_expense_feed_dists fd
192: WHERE fl.employee_verification_id = l_new_emp_verification_id
193: OR fd.employee_verification_id = l_new_emp_verification_id;
194:
354: CURSOR Manager_Approval_Workflows IS
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,
449: SET manager_approval_id = l_new_manager_approval_id
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
724: l_debug_info VARCHAR2(2000);
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);
919: SET status_lookup_code = 'APPROVED'
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
1054: fl.amount,
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
1434: fl.amount,
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