APPS.PAY_IP_STARTUP_UTIL dependencies on PAY_ELEMENT_CLASSIFICATIONS

Line 325: FROM dual WHERE EXISTS (SELECT NULL FROM pay_element_classifications

321:
322: BEGIN
323: SELECT 1
324: INTO l_reference
325: FROM dual WHERE EXISTS (SELECT NULL FROM pay_element_classifications
326: WHERE nvl(legislation_code,'X') = 'ZZ'
327: AND business_group_id IS NULL);
328:
329: EXCEPTION

Line 629: FROM pay_element_classifications

625: legislation_subgroup,costable_flag,default_high_priority,default_low_priority,
626: default_priority,distributable_over_flag,non_payments_flag,costing_debit_or_credit,
627: parent_classification_id,create_by_default_flag,last_update_date,last_updated_by,
628: last_update_login,created_by,creation_date,balance_initialization_flag,object_version_number
629: FROM pay_element_classifications
630: WHERE nvl(legislation_code,'X') = 'ZZ'
631: AND business_group_id IS NULL;
632:
633: CURSOR get_balance_type_csr IS

Line 706: ,pay_element_classifications pec

702: SELECT ao.key_name
703: ,ao.product_name
704: ,ao.key_value
705: FROM hr_application_ownerships ao
706: ,pay_element_classifications pec
707: WHERE pec.legislation_code = 'ZZ'
708: AND ao.key_name = 'CLASSIFICATION_ID'
709: AND TO_NUMBER(ao.key_value) = pec.classification_id
710: UNION ALL

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