APPS.IBY_UPG_PPP_PKG dependencies on IBY_ACCT_PMT_PROFILES_B

Line 326: AD_ZD_SEED.PREPARE('iby_acct_pmt_profiles_b');

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');
330: AD_ZD_SEED.PREPARE('iby_instr_creation_rules');

Line 926: iby_acct_pmt_profiles_b app,

922: SELECT distinct(ppb.system_profile_code) system_profile_code
923: FROM iby_formats_b ipf,
924: iby_upg_ppp_tl ppp,
925: iby_upg_ppp_b ppb,
926: iby_acct_pmt_profiles_b app,
927: iby_bepinfo bep,
928: iby_bepkeys key1
929: WHERE(ipf.reference_format_code IS NULL OR(ipf.reference_format_code IS NOT NULL
930: AND ipf.reference_format_code NOT IN

Line 1150: update iby_acct_pmt_profiles_b set

1146: /*if (sql%notfound) then
1147: raise no_data_found;
1148: end if;*/
1149:
1150: update iby_acct_pmt_profiles_b set
1151: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
1152: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
1153: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
1154: BEP_ACCOUNT_ID = X_BEP_ACCOUNT_ID

Line 1926: INTO iby_acct_pmt_profiles_b

1922: batch_booking_flag,
1923: inactive_date
1924: )
1925: WHEN create_bepacct=1 THEN
1926: INTO iby_acct_pmt_profiles_b
1927: (
1928: payment_profile_id,
1929: system_profile_code,
1930: created_by,

Line 1953: iby_acct_pmt_profiles_b_s.NEXTVAL,

1949: ack_sec_config_id,
1950: ack_transmit_config_id
1951: ) VALUES
1952: (
1953: iby_acct_pmt_profiles_b_s.NEXTVAL,
1954: check_format_id, -- system_profile_code
1955: created_by, -- created_by
1956: creation_date, -- creation_date
1957: last_updated_by, -- last_updated_by

Line 2920: iby_acct_pmt_profiles_b app,

2916: ap_payment_programs pp,
2917: iby_formats_b ipf,
2918: iby_upg_ppp_tl ppp,
2919: iby_upg_ppp_b ppb,
2920: iby_acct_pmt_profiles_b app,
2921: iby_bepinfo bep,
2922: iby_bepkeys key,
2923: (SELECT SUBSTR(sfa.jgzz_attribute_category,
2924: LENGTH(sfa.jgzz_country_code)+2,

Line 2962: iby_acct_pmt_profiles_b app,

2958: FROM
2959: iby_formats_b ipf,
2960: iby_upg_ppp_tl ppp,
2961: iby_upg_ppp_b ppb,
2962: iby_acct_pmt_profiles_b app,
2963: iby_bepinfo bep,
2964: iby_bepkeys key
2965: WHERE (ipf.reference_format_code IS NULL OR
2966: (ipf.reference_format_code IS NOT NULL AND