APPS.PAY_IP_STARTUP_UTIL dependencies on PAY_BALANCE_TYPES

Line 642: FROM pay_balance_types

638: attribute1, attribute2, attribute3, attribute4, attribute5, attribute6, attribute7,
639: attribute8, attribute9, attribute10, attribute11, attribute12, attribute13, attribute14,
640: attribute15, attribute16, attribute17, attribute18, attribute19, attribute20,
641: last_update_date, last_updated_by, last_update_login, created_by, creation_date
642: FROM pay_balance_types
643: WHERE nvl(legislation_code,'X') = 'ZZ'
644: AND business_group_id IS NULL;
645:
646: CURSOR get_defined_balances_csr IS

Line 652: FROM pay_defined_balances d, pay_balance_types b

648: d.defined_balance_id, d.business_group_id, d.legislation_code, d.balance_type_id,
649: d.balance_dimension_id, d.force_latest_balance_flag, d.legislation_subgroup,
650: d.last_update_date, d.last_updated_by, d.last_update_login, d.created_by, d.creation_date,
651: d.object_version_number, d.grossup_allowed_flag, b.balance_name bname
652: FROM pay_defined_balances d, pay_balance_types b
653: WHERE d.balance_type_id = b.balance_type_id
654: AND EXISTS (SELECT NULL FROM hr_s_balance_types b
655: WHERE d.balance_type_id = b.balance_type_id);
656:

Line 715: ,pay_balance_types pbt

711: SELECT ao.key_name
712: ,ao.product_name
713: ,ao.key_value
714: FROM hr_application_ownerships ao
715: ,pay_balance_types pbt
716: WHERE pbt.legislation_code = 'ZZ'
717: AND ao.key_name = 'BALANCE_TYPE_ID'
718: AND TO_NUMBER(ao.key_value) = pbt.balance_type_id
719: UNION ALL

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