DBA Data[Home] [Help]

APPS.PO_XML_DELIVERY dependencies on AP_CARDS_ALL

Line 1118: from ap_cards_all aca, ap_card_programs_all acpa, po_headers_all pha

1114: if(p_document_type = 'STANDARD') then
1115: select aca.card_number, aca.cardmember_name,aca.card_expiration_date,
1116: acpa.card_brand_lookup_code
1117: into p_card_num, p_card_name, p_card_exp_date, p_card_brand
1118: from ap_cards_all aca, ap_card_programs_all acpa, po_headers_all pha
1119: where pha.po_header_id = p_header_id
1120: and pha.pcard_id = aca.card_id
1121: and aca.card_program_id = acpa.card_program_id;
1122: else

Line 1126: from ap_cards_all aca, ap_card_programs_all acpa, po_releases_all pra

1122: else
1123: select aca.card_number, aca.cardmember_name,aca.card_expiration_date,
1124: acpa.card_brand_lookup_code
1125: into p_card_num, p_card_name, p_card_exp_date, p_card_brand
1126: from ap_cards_all aca, ap_card_programs_all acpa, po_releases_all pra
1127: where pra.po_header_id = p_header_id
1128: and pra.po_release_id = p_release_id
1129: and pra.pcard_id = aca.card_id
1130: and aca.card_program_id = acpa.card_program_id;