DBA Data[Home] [Help]

APPS.PAY_MLS_TRIGGERS dependencies on PAY_BALANCE_CATEGORIES_F_TL

Line 186: from pay_balance_categories_f_tl tl

182: where b.balance_category_id = p_balance_category_id
183: and not exists
184: -- this is the first insert ; there is no corresponding row in tl table
185: ( select 1
186: from pay_balance_categories_f_tl tl
187: where tl.balance_category_id = p_balance_category_id ) ;
188: rec_pbc c_pbc%rowtype;
189: begin
190: l_proc := 'pbc_asi' ;

Line 218: from pay_balance_categories_f_tl p

214: l_proc varchar2(30) ;
215: cursor c_pbc_del ( p_balance_category_id pay_balance_categories_f.balance_category_id%type )
216: is
217: select 1
218: from pay_balance_categories_f_tl p
219: where p.balance_category_id = p_balance_category_id
220: and not exists
221: ( select 1
222: from pay_balance_categories_f p1