APPS.PAY_IP_STARTUP_UTIL dependencies on PAY_BALANCE_TYPES_TL

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);