DBA Data[Home] [Help]

APPS.AP_WEB_MATCHING_RULE_PKG dependencies on AP_CARDS_ALL

Line 7: select card_id from ap_cards_all where card_id = p_card_id

3:
4: --
5: -- Cursor used to lock CARD record
6: cursor ccard(p_card_id number) is
7: select card_id from ap_cards_all where card_id = p_card_id
8: for update of card_id;
9:
10:
11: --

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

163: trunc(sysdate),
164: fnd_global.user_id,
165: trunc(sysdate),
166: fnd_global.login_id
167: FROM PER_ALL_PEOPLE_F pap, FINANCIALS_SYSTEM_PARAMS_ALL fsp, PER_PERSON_TYPES ppt, AP_CARDS_ALL card
168: WHERE
169: card.CARD_ID = :cardId
170: AND card.ORG_ID = fsp.ORG_ID
171: AND TRUNC(sysdate) BETWEEN pap.effective_start_date AND pap.effective_end_date