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_CARD_VALIDATE_PKG dependencies on HR_EMPLOYEES_CURRENT_V

Line 323: from hr_employees_current_v hremp

319: update ap_expense_feed_lines efl
320: set reject_code = 'EMPLOYEE NOT VALID'
321: where not exists
322: (select 1
323: from hr_employees_current_v hremp
324: where efl.employee_id = hremp.employee_id
325: )
326: and exists (select 1 from ap_card_programs cp
327: where cp.card_program_id = efl.card_program_id

Line 341: and not exists (select 'employee is in hr_employees_current_v'

337:
338: update ap_expense_feed_lines efl
339: set reject_code = 'EMPLOYEE INACTIVE'
340: where reject_code = 'UNTESTED'
341: and not exists (select 'employee is in hr_employees_current_v'
342: from hr_employees_current_v hremp
343: where hremp.employee_id = efl.employee_id)
344: and card_id is not null
345: and card_program_id = P_CARD_PROGRAM_ID

Line 342: from hr_employees_current_v hremp

338: update ap_expense_feed_lines efl
339: set reject_code = 'EMPLOYEE INACTIVE'
340: where reject_code = 'UNTESTED'
341: and not exists (select 'employee is in hr_employees_current_v'
342: from hr_employees_current_v hremp
343: where hremp.employee_id = efl.employee_id)
344: and card_id is not null
345: and card_program_id = P_CARD_PROGRAM_ID
346: and posted_date between nvl(P_START_DATE, posted_date - 1) and

Line 404: -- top of Employee Acct CCID (from HR_EMPLOYEES_CURRENT_V).

400: -- Creates records in AP_EXPENSE_FEED_DISTS where CDF=Y.
401: -- CCID determined by looking at the BAFCF.
402: -- o If BAFCF=Y then use overlay account defined by CODE_ID on
403: -- top of DEFAULT_ACCT_TEMPLATE. Overlay resulting segments on
404: -- top of Employee Acct CCID (from HR_EMPLOYEES_CURRENT_V).
405: -- o If BAFCF=N overlay account segments defined in
406: -- DEFAULT_ACCT_TEMPLATE on top of Employee Acct CCID (from
407: -- HR_EMPLOYEES_CURRENT_V).
408: -- o If error results from operations above, use

Line 407: -- HR_EMPLOYEES_CURRENT_V).

403: -- top of DEFAULT_ACCT_TEMPLATE. Overlay resulting segments on
404: -- top of Employee Acct CCID (from HR_EMPLOYEES_CURRENT_V).
405: -- o If BAFCF=N overlay account segments defined in
406: -- DEFAULT_ACCT_TEMPLATE on top of Employee Acct CCID (from
407: -- HR_EMPLOYEES_CURRENT_V).
408: -- o If error results from operations above, use
409: -- AP_CARD_PROFILES.EXCEPTION_CLEARING_CCID. If CCID not defined at
410: -- profile, use AP_CARD_PROGRAMS.EXCEPTION_CLEARING_CCID.
411: -- o If CCID still cannot be determined, populate REJECT_CODE to flag

Line 428: l_default_emp_ccid HR_EMPLOYEES_CURRENT_V.default_code_combination_id%TYPE;

424: P_START_DATE IN DATE DEFAULT NULL,
425: P_END_DATE IN DATE DEFAULT NULL,
426: P_RETURN_ERROR_MESSAGE IN OUT NOCOPY VARCHAR2,
427: P_REQUEST_ID IN NUMBER) IS
428: l_default_emp_ccid HR_EMPLOYEES_CURRENT_V.default_code_combination_id%TYPE;
429: l_default_emp_segments FND_FLEX_EXT.SEGMENTARRAY;
430: l_final_segments FND_FLEX_EXT.SEGMENTARRAY;
431: l_def_acct_template_array FND_FLEX_EXT.SEGMENTARRAY;
432: l_exp_line_acct_segs_array FND_FLEX_EXT.SEGMENTARRAY;

Line 499: hr_employees_current_v hremp,

495: from ap_expense_feed_lines efl,
496: ap_card_programs cpg,
497: ap_card_profiles cpr,
498: ap_cards c,
499: hr_employees_current_v hremp,
500: IBY_FNDCPT_PAYER_ALL_INSTRS_V IBY
501: where efl.card_id = c.card_id
502: and c.card_reference_id=IBY.instrument_id
503: and c.profile_id = cpr.profile_id