[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select actual_completion_date INTO l_from_date from (
select actual_completion_date from fnd_concurrent_requests req,
FND_CONCURRENT_PROGRAMS prg where req.concurrent_program_id = prg.concurrent_program_id
and prg.concurrent_program_name = 'POSSUPPUBJOB' and actual_completion_date is not null
order by actual_completion_date desc) where rownum=1;
SELECT party_id
BULK COLLECT
INTO partyid_list
FROM (SELECT party_id
FROM ap_suppliers
WHERE last_update_date BETWEEN l_from_date AND l_to_date
UNION
SELECT ap.party_id
FROM hz_parties hz,
ap_suppliers ap
WHERE hz.party_id = ap.party_id
AND hz.last_update_date BETWEEN l_from_date AND l_to_date
UNION
SELECT ap.party_id
FROM ap_supplier_sites_all aps,
ap_suppliers ap
WHERE aps.vendor_id = ap.vendor_id
AND aps.last_update_date BETWEEN l_from_date AND l_to_date
UNION
SELECT ap.party_id
FROM hz_locations hz,
ap_suppliers ap,
ap_supplier_sites_all ss
WHERE ss.vendor_id = ap.vendor_id
AND hz.location_id = ss.location_id
AND hz.last_update_date BETWEEN l_from_date AND l_to_date
UNION
SELECT ap.party_id
FROM pos_bus_class_attr pbca,
ap_suppliers ap
WHERE pbca.vendor_id = ap.vendor_id
AND pbca.last_update_date BETWEEN l_from_date AND l_to_date
UNION
SELECT ap.party_id
FROM iby_pmt_instr_uses_all instr,
iby_external_payees_all payee,
ap_suppliers ap
WHERE instr.ext_pmt_party_id = payee.ext_payee_id
AND payee.payee_party_id = ap.party_id
AND instr.last_update_date BETWEEN l_from_date AND l_to_date
UNION
SELECT ap.party_id
FROM iby_external_payees_all payee,
ap_suppliers ap
WHERE payee.payee_party_id = ap.party_id
AND payee.last_update_date BETWEEN l_from_date AND l_to_date
UNION
SELECT ap.party_id
FROM zx_party_tax_profile tax,
ap_suppliers ap
WHERE tax.party_id = ap.party_id
AND tax.last_update_date BETWEEN l_from_date AND l_to_date
UNION
SELECT ap.party_id
FROM ap_supplier_contacts apsc,
ap_suppliers ap,
ap_supplier_sites_all sa
WHERE sa.vendor_id = ap.vendor_id
AND apsc.vendor_site_id = sa.vendor_site_id
AND apsc.last_update_date BETWEEN l_from_date AND l_to_date
UNION
SELECT ap.party_id
FROM pos_sup_products_services ps,
ap_suppliers ap
WHERE ps.vendor_id = ap.vendor_id
AND ps.last_update_date BETWEEN l_from_date AND l_to_date
UNION
SELECT ap.party_id
FROM hz_organization_profiles bapr,
hz_organization_profiles brpr,
hz_parties bp,
hz_party_sites s,
iby_account_owners ow,
hz_parties br,
ap_suppliers ap,
iby_ext_bank_accounts eb,
hz_code_assignments branchca,
hz_contact_points branchcp
WHERE eb.bank_id = bp.party_id(+)
AND eb.bank_id = bapr.party_id(+)
AND eb.branch_id = br.party_id(+)
AND eb.branch_id = brpr.party_id(+)
AND eb.ext_bank_account_id = ow.ext_bank_account_id
AND ow.primary_flag(+) = 'Y'
AND nvl(ow.end_date, SYSDATE + 10) > SYSDATE
AND ow.account_owner_party_id = ap.party_id
AND (br.party_id = s.party_id(+))
AND (s.identifying_address_flag(+) = 'Y')
AND (branchcp.owner_table_name(+) = 'HZ_PARTIES')
AND (branchcp.owner_table_id(+) = eb.branch_id)
AND (branchcp.contact_point_type(+) = 'EFT')
AND (nvl(branchcp.status(+), 'A') = 'A')
AND (branchca.class_category(+) =
'BANK_INSTITUTION_TYPE')
AND (branchca.owner_table_name(+) = 'HZ_PARTIES')
AND (branchca.owner_table_id(+) = eb.branch_id)
AND eb.last_update_date BETWEEN l_from_date AND l_to_date
UNION
SELECT ap.party_id
FROM ap_suppliers ap,
pos_supp_prof_ext_b ext
WHERE ap.party_id = ext.party_id
AND ext.last_update_date BETWEEN l_from_date AND l_to_date);
pos_supp_pub_raise_event_pkg.get_bo_and_insert(partyid_list,
p_publication_event_id,
p_published_by,
p_publish_detail);
SELECT pos_supp_pub_event_s.nextval
INTO g_curr_supp_publish_event_id
FROM dual;