DBA Data[Home] [Help]

APPS.AP_WEB_EMP_NUM_MATCH_PKG dependencies on FINANCIALS_SYSTEM_PARAMS_ALL

Line 39: FROM PER_ALL_PEOPLE_F pap, FINANCIALS_SYSTEM_PARAMS_ALL fsp, PER_PERSON_TYPES ppt, AP_CARDS_ALL card

35: trunc(sysdate),
36: fnd_global.user_id,
37: trunc(sysdate),
38: fnd_global.login_id
39: FROM PER_ALL_PEOPLE_F pap, FINANCIALS_SYSTEM_PARAMS_ALL fsp, PER_PERSON_TYPES ppt, AP_CARDS_ALL card
40: WHERE
41: card.CARD_ID = p_card_id
42: AND card.ORG_ID = fsp.ORG_ID
43: AND TRUNC(sysdate) BETWEEN pap.effective_start_date AND pap.effective_end_date