DBA Data[Home] [Help]

APPS.AP_WEB_LOCATIONS_PKG dependencies on AP_CARD_PROGRAMS_ALL

Line 230: from ap_card_programs_all card,

226: --
227: begin
228: select site.country
229: into l_country
230: from ap_card_programs_all card,
231: ap_supplier_sites_all site
232: where card.vendor_site_id = site.vendor_site_id
233: and card.card_program_id = p_card_program_id;
234:

Line 247: from ap_card_programs_all card,

243: --
244: begin
245: select curr.issuing_territory_code
246: into l_country
247: from ap_card_programs_all card,
248: fnd_currencies curr
249: where card.card_program_id = p_card_program_id
250: and card.card_program_currency_code = curr.currency_code;
251:

Line 268: ap_card_programs_all p

264: select loc.country
265: into l_country
266: from hr_all_organization_units org,
267: hr_locations loc,
268: ap_card_programs_all p
269: where org.location_id = loc.location_id
270: and org.organization_id = p.org_id
271: and p.card_program_id = p_card_program_id;
272:

Line 298: from ap_card_programs_all

294: end if;
295:
296: if p_card_program_id is not null then
297: select org_id into p_location.org_id
298: from ap_card_programs_all
299: where card_program_id = p_card_program_id;
300: end if;
301: end default_org_id;
302: