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