APPS.PAY_IP_STARTUP_UTIL dependencies on PAY_BALANCE_CATEGORIES_F_TL

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;