APPS.PAY_IP_STARTUP_UTIL dependencies on PAY_BALANCE_CATEGORIES

Line 772: FROM pay_balance_categories_f

768: pbc_information15 ,pbc_information16 ,pbc_information17 ,pbc_information18 ,pbc_information19 ,pbc_information20 ,
769: pbc_information21 ,pbc_information22 ,pbc_information23 ,pbc_information24 ,pbc_information25 ,pbc_information26 ,
770: pbc_information27 ,pbc_information28 ,pbc_information29 ,pbc_information30 ,last_update_date ,last_updated_by ,
771: last_update_login ,created_by ,creation_date ,object_version_number ,user_category_name
772: FROM pay_balance_categories_f
773: WHERE nvl(legislation_code,'X') = 'ZZ'
774: AND business_group_id IS NULL;
775:
776: /*bug 10212578 End */

Line 873: pay_balance_categories pbc

869: SELECT ao.key_name
870: ,ao.product_name
871: ,ao.key_value
872: FROM hr_application_ownerships ao,
873: pay_balance_categories pbc
874: WHERE pbc.legislation_code ='ZZ'
875: AND ao.key_name = 'BALANCE_CATEGORY_ID'
876: AND TO_NUMBER(ao.key_value) = pbc.balance_category_id;
877:

Line 2052: FROM pay_balance_categories_f_tl t, pay_balance_categories_f b

2048:
2049: CURSOR get_balcat_btable_csr IS
2050: SELECT b.balance_category_id bid , t.user_category_name tname,b.user_category_name bname,
2051: t.language, t.source_lang
2052: FROM pay_balance_categories_f_tl t, pay_balance_categories_f b
2053: WHERE b.balance_category_id = t.balance_category_id
2054: AND b.legislation_code = 'ZZ'
2055: AND b.business_group_id IS NULL;
2056:

Line 2060: FROM pay_balance_categories_f b, pay_balance_categories_f_tl t

2056:
2057:
2058: CURSOR get_balcat_tltable_csr(l_legislation_code VARCHAR2 , l_name VARCHAR2 , l_language VARCHAR2) IS
2059: SELECT t.balance_category_id tlid
2060: FROM pay_balance_categories_f b, pay_balance_categories_f_tl t
2061: WHERE b.user_category_name = l_name
2062: AND b.legislation_code = l_legislation_code
2063: AND b.business_group_id is NULL
2064: AND t.balance_category_id = b.balance_category_id

Line 2080: UPDATE pay_balance_categories_f_tl

2076: fetch get_balcat_tltable_csr INTO rec_tltable_csr ;
2077:
2078: if get_balcat_tltable_csr%found then
2079:
2080: UPDATE pay_balance_categories_f_tl
2081: SET user_category_name = l_record.tname,
2082: source_lang = l_record.source_lang
2083: WHERE balance_category_id = rec_tltable_csr.tlid
2084: AND language = l_record.language;