APPS.PAY_IP_STARTUP_UTIL dependencies on PAY_ELEMENT_CLASSIFICATIONS_TL

Line 1550: FROM pay_element_classifications_tl t, pay_element_classifications b

1546:
1547: CURSOR get_classid_btable_csr IS
1548: SELECT b.classification_id bid , b.classification_name bname,
1549: t.language, t.classification_name tname, t.description, t.source_lang
1550: FROM pay_element_classifications_tl t, pay_element_classifications b
1551: WHERE b.classification_id = t.classification_id
1552: AND b.legislation_code = 'ZZ'
1553: AND b.business_group_id IS NULL;
1554:

Line 1558: FROM pay_element_classifications_tl t, pay_element_classifications b

1554:
1555:
1556: CURSOR get_classid_tltable_csr(l_legislation_code VARCHAR2 , l_name VARCHAR2 , l_language VARCHAR2) IS
1557: SELECT t.classification_id tlid
1558: FROM pay_element_classifications_tl t, pay_element_classifications b
1559: WHERE b.classification_name = l_name
1560: AND b.legislation_code = l_legislation_code
1561: AND b.business_group_id is NULL
1562: AND t.classification_id = b.classification_id

Line 1578: UPDATE pay_element_classifications_tl

1574: fetch get_classid_tltable_csr INTO rec_tltable_csr ;
1575:
1576: if get_classid_tltable_csr%found then
1577:
1578: UPDATE pay_element_classifications_tl
1579: SET classification_name = l_record.tname,
1580: description = l_record.description,
1581: source_lang = l_record.source_lang
1582: WHERE classification_id = rec_tltable_csr.tlid

Line 2261: write_log('LOG','PAY_34015_IP_UPD_TABLE','PAY_ELEMENT_CLASSIFICATIONS_TL',NULL);

2257: write_log('LOG',NULL,NULL,NULL);
2258: write_log('LOG','PAY_34017_IP_UPD_TL_TABLE',NULL,NULL);
2259:
2260: hr_utility.set_location('pay_ip_startup_util.setup',90);
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);