DBA Data[Home] [Help]

APPS.PAY_MLS_TRIGGERS dependencies on PAY_USER_ROWS_F_TL

Line 68: from pay_user_rows_f_tl tl

64: where b.user_row_id = p_user_row_id
65: and not exists
66: -- this is the first insert ; there is no corresponding row in tl table
67: ( select 1
68: from pay_user_rows_f_tl tl
69: where tl.user_row_id = p_user_row_id ) ;
70: rec_pur c_pur%rowtype;
71: begin
72:

Line 103: from pay_user_rows_f_tl p

99: l_proc varchar2(30) := 'pur_asd' ;
100: cursor c_pur_del ( p_user_row_id pay_user_rows_f.user_row_id%type )
101: is
102: select 1
103: from pay_user_rows_f_tl p
104: where p.user_row_id = p_user_row_id
105: and not exists
106: ( select 1
107: from pay_user_rows_f p1