APPS.IBY_UPG_PPP_PKG dependencies on IBY_APPLICABLE_PMT_PROFS

Line 328: AD_ZD_SEED.PREPARE('iby_applicable_pmt_profs');

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');
331: AD_ZD_SEED.PREPARE('iby_remit_advice_setup'); */
332:

Line 1683: FROM iby_applicable_pmt_profs app

1679: ---------------------------------------------------------------------------
1680: BEGIN
1681: SELECT NVL(MAX(applicable_pmt_prof_id),0)
1682: INTO l_max_app
1683: FROM iby_applicable_pmt_profs app
1684: WHERE applicable_pmt_prof_id < 10000;
1685: EXCEPTION
1686: WHEN no_data_found THEN
1687: l_max_app := 0;

Line 1979: INTO iby_applicable_pmt_profs

1975: NULL -- ack_transmit_config_id
1976: )
1977: -- applicable pmt method
1978: WHEN create_header = 1 THEN
1979: INTO iby_applicable_pmt_profs
1980: (
1981: applicable_pmt_prof_id,
1982: system_profile_code,
1983: applicable_type_code,

Line 2010: INTO iby_applicable_pmt_profs

2006: object_version_number -- object_version_number
2007: )
2008: -- applicable currency
2009: WHEN create_header = 1 THEN
2010: INTO iby_applicable_pmt_profs
2011: (
2012: applicable_pmt_prof_id,
2013: system_profile_code,
2014: applicable_type_code,

Line 2043: INTO iby_applicable_pmt_profs

2039: object_version_number -- object_version_number
2040: )
2041: -- applicable organizations
2042: WHEN create_header = 1 THEN
2043: INTO iby_applicable_pmt_profs
2044: (
2045: applicable_pmt_prof_id,
2046: system_profile_code,
2047: applicable_type_code,

Line 2074: INTO iby_applicable_pmt_profs

2070: object_version_number -- object_version_number
2071: )
2072: -- applicable internal bank account
2073: WHEN create_intba = 1 THEN
2074: INTO iby_applicable_pmt_profs
2075: (
2076: applicable_pmt_prof_id,
2077: system_profile_code,
2078: applicable_type_code,

Line 2992: FROM iby_applicable_pmt_profs app

2988: ---------------------------------------------------------------------------
2989: BEGIN
2990: SELECT NVL(MAX(applicable_pmt_prof_id),0)
2991: INTO l_max_app
2992: FROM iby_applicable_pmt_profs app
2993: WHERE applicable_pmt_prof_id < 10000;
2994: EXCEPTION
2995: WHEN no_data_found THEN
2996: l_max_app := 0;

Line 3000: INSERT INTO iby_applicable_pmt_profs

2996: l_max_app := 0;
2997: END;
2998:
2999: BEGIN
3000: INSERT INTO iby_applicable_pmt_profs
3001: (
3002: applicable_pmt_prof_id,
3003: system_profile_code,
3004: applicable_type_code,

Line 3028: FROM iby_applicable_pmt_profs apm,

3024: apm.last_updated_by,
3025: apm.last_update_date,
3026: apm.last_update_login,
3027: apm.object_version_number
3028: FROM iby_applicable_pmt_profs apm,
3029: iby_sys_pmt_profiles_b ppp,
3030: iby_payment_methods_b pm
3031: WHERE ppp.system_profile_code = apm.system_profile_code
3032: AND ppp.payment_format_code = 'IBY_PAY_ECE'

Line 3036: FROM iby_applicable_pmt_profs a

3032: AND ppp.payment_format_code = 'IBY_PAY_ECE'
3033: AND apm.applicable_type_code = 'PAYMENT_METHOD'
3034: AND pm.payment_method_code like 'DK%'
3035: AND NOT EXISTS (SELECT a.applicable_pmt_prof_id
3036: FROM iby_applicable_pmt_profs a
3037: WHERE a.system_profile_code = ppp.system_profile_code
3038: AND a.applicable_type_code = 'PAYMENT_METHOD'
3039: AND a.applicable_value_to = pm.payment_method_code);
3040: EXCEPTION