APPS.PAY_IP_STARTUP_UTIL dependencies on PAY_BALANCE_TYPES_TL

Line 1612: FROM pay_balance_types_tl t, pay_balance_types b

1608: --old reference data ids
1609: CURSOR get_balid_btable_csr IS
1610: SELECT b.balance_type_id bid , b.balance_name bname ,
1611: t.language, t.balance_name tname, t.reporting_name, t.source_lang
1612: FROM pay_balance_types_tl t, pay_balance_types b
1613: WHERE t.balance_type_id = b.balance_type_id
1614: AND b.legislation_code = 'ZZ'
1615: AND b.business_group_id IS NULL ;
1616:

Line 1620: FROM pay_balance_types_tl t, pay_balance_types b

1616:
1617: --ids for newly created data
1618: CURSOR get_balid_tltable_csr(l_legislation_code VARCHAR2, l_name VARCHAR2 , l_language VARCHAR2 ) IS
1619: SELECT t.balance_type_id tlid
1620: FROM pay_balance_types_tl t, pay_balance_types b
1621: WHERE b.balance_name = l_name
1622: AND b.legislation_code = l_legislation_code
1623: AND b.business_group_id IS NULL
1624: AND b.balance_type_id = t.balance_type_id

Line 1639: UPDATE pay_balance_types_tl

1635: fetch get_balid_tltable_csr INTO rec_tltable_csr;
1636:
1637: if get_balid_tltable_csr%found then
1638:
1639: UPDATE pay_balance_types_tl
1640: SET balance_name = l_record.tname,
1641: reporting_name = l_record.reporting_name,
1642: source_lang = l_record.source_lang
1643: WHERE balance_type_id = rec_tltable_csr.tlid

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

2261: write_log('LOG','PAY_34015_IP_UPD_TABLE','PAY_ELEMENT_CLASSIFICATIONS_TL',NULL);
2262: update_ele_class_tl(p_legislation_code);
2263:
2264: hr_utility.set_location('pay_ip_startup_util.setup',100);
2265: write_log('LOG','PAY_34015_IP_UPD_TABLE','PAY_BALANCE_TYPES_TL',NULL);
2266: update_bal_type_tl(p_legislation_code);
2267:
2268: --Run Types
2269: hr_utility.set_location('pay_ip_startup_util.setup',110);