APPS.PAY_IP_STARTUP_UTIL dependencies on PAY_BALANCE_TYPES

Line 704: FROM pay_balance_types

700: attribute1, attribute2, attribute3, attribute4, attribute5, attribute6, attribute7,
701: attribute8, attribute9, attribute10, attribute11, attribute12, attribute13, attribute14,
702: attribute15, attribute16, attribute17, attribute18, attribute19, attribute20,
703: last_update_date, last_updated_by, last_update_login, created_by, creation_date
704: FROM pay_balance_types
705: WHERE nvl(legislation_code,'X') = 'ZZ'
706: AND business_group_id IS NULL;
707:
708: CURSOR get_defined_balances_csr IS

Line 714: FROM pay_defined_balances d, pay_balance_types b

710: d.defined_balance_id, d.business_group_id, d.legislation_code, d.balance_type_id,
711: d.balance_dimension_id, d.force_latest_balance_flag, d.legislation_subgroup,
712: d.last_update_date, d.last_updated_by, d.last_update_login, d.created_by, d.creation_date,
713: d.object_version_number, d.grossup_allowed_flag, b.balance_name bname
714: FROM pay_defined_balances d, pay_balance_types b
715: WHERE d.balance_type_id = b.balance_type_id
716: AND EXISTS (SELECT NULL FROM hr_s_balance_types b
717: WHERE d.balance_type_id = b.balance_type_id);
718:

Line 822: ,pay_balance_types pbt

818: SELECT ao.key_name
819: ,ao.product_name
820: ,ao.key_value
821: FROM hr_application_ownerships ao
822: ,pay_balance_types pbt
823: WHERE pbt.legislation_code = 'ZZ'
824: AND ao.key_name = 'BALANCE_TYPE_ID'
825: AND TO_NUMBER(ao.key_value) = pbt.balance_type_id
826: UNION ALL

Line 2113: FROM pay_balance_types_tl t, pay_balance_types b

2109: --old reference data ids
2110: CURSOR get_balid_btable_csr IS
2111: SELECT b.balance_type_id bid , b.balance_name bname ,
2112: t.language, t.balance_name tname, t.reporting_name, t.source_lang
2113: FROM pay_balance_types_tl t, pay_balance_types b
2114: WHERE t.balance_type_id = b.balance_type_id
2115: AND b.legislation_code = 'ZZ'
2116: AND b.business_group_id IS NULL ;
2117:

Line 2121: FROM pay_balance_types_tl t, pay_balance_types b

2117:
2118: --ids for newly created data
2119: CURSOR get_balid_tltable_csr(l_legislation_code VARCHAR2, l_name VARCHAR2 , l_language VARCHAR2 ) IS
2120: SELECT t.balance_type_id tlid
2121: FROM pay_balance_types_tl t, pay_balance_types b
2122: WHERE b.balance_name = l_name
2123: AND b.legislation_code = l_legislation_code
2124: AND b.business_group_id IS NULL
2125: AND b.balance_type_id = t.balance_type_id

Line 2140: UPDATE pay_balance_types_tl

2136: fetch get_balid_tltable_csr INTO rec_tltable_csr;
2137:
2138: if get_balid_tltable_csr%found then
2139:
2140: UPDATE pay_balance_types_tl
2141: SET balance_name = l_record.tname,
2142: reporting_name = l_record.reporting_name,
2143: source_lang = l_record.source_lang
2144: WHERE balance_type_id = rec_tltable_csr.tlid

Line 3502: write_log('LOG','PAY_34015_IP_UPD_TABLE','PAY_BALANCE_TYPES_TL',NULL);

3498: write_log('LOG','PAY_34015_IP_UPD_TABLE','PAY_ELEMENT_CLASSIFICATIONS_TL',NULL);
3499: update_ele_class_tl(p_legislation_code);
3500:
3501: hr_utility.set_location('pay_ip_startup_util.setup',100);
3502: write_log('LOG','PAY_34015_IP_UPD_TABLE','PAY_BALANCE_TYPES_TL',NULL);
3503: update_bal_type_tl(p_legislation_code);
3504:
3505: --Run Types
3506: hr_utility.set_location('pay_ip_startup_util.setup',110);