APPS.IBY_UPG_PPP_PKG dependencies on IBY_SYS_PMT_PROFILES_TL

Line 325: AD_ZD_SEED.PREPARE('iby_sys_pmt_profiles_tl');

321: end if;
322: close c;
323: -- New for Online Patching
324: /* AD_ZD_SEED.PREPARE('iby_sys_pmt_profiles_b');
325: AD_ZD_SEED.PREPARE('iby_sys_pmt_profiles_tl');
326: AD_ZD_SEED.PREPARE('iby_acct_pmt_profiles_b');
327: AD_ZD_SEED.PREPARE('iby_acct_pmt_profiles_tl');
328: AD_ZD_SEED.PREPARE('iby_applicable_pmt_profs');
329: AD_ZD_SEED.PREPARE('iby_pmt_creation_rules');

Line 1246: update IBY_SYS_PMT_PROFILES_TL set

1242: if (sql%notfound) then
1243: raise no_data_found;
1244: end if;
1245:
1246: update IBY_SYS_PMT_PROFILES_TL set
1247: SYSTEM_PROFILE_NAME = X_SYSTEM_PROFILE_NAME,
1248: SYSTEM_PROFILE_DESCRIPTION = X_SYSTEM_PROFILE_DESCRIPTION,
1249: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
1250: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 2795: INTO iby_sys_pmt_profiles_tl

2791: ---------------------------------------------------------------------------
2792: BEGIN
2793: INSERT ALL
2794: WHEN create_header = 1 THEN
2795: INTO iby_sys_pmt_profiles_tl
2796: (
2797: system_profile_code,
2798: system_profile_name,
2799: language,

Line 2979: FROM iby_sys_pmt_profiles_tl spp);

2975: AND ppp.system_profile_code = ppb.system_profile_code
2976: AND ppb.bep_suffix = bep.suffix(+)
2977: AND app.bep_account_id = key.bep_account_id(+)) i
2978: WHERE i.system_profile_code NOT IN (SELECT spp.system_profile_code
2979: FROM iby_sys_pmt_profiles_tl spp);
2980: EXCEPTION
2981: WHEN others THEN NULL;
2982:
2983: END;