APPS.IBU_ALERT_BIN dependencies on JTF_RS_RESOURCE_EXTNS

Line 131: from jtf_rs_resource_extns a, fnd_user b

127:
128: If (l_employee_id is not null ) Then
129: select resource_id
130: into resource_id
131: from jtf_rs_resource_extns a, fnd_user b
132: where a.source_id = b.employee_id
133: and a.category = 'EMPLOYEE'
134: and b.user_id = p_user_id
135: and ( (a.end_date_active is null ) Or (a.end_date_active > sysdate) );

Line 139: from jtf_rs_resource_extns a, fnd_user b

135: and ( (a.end_date_active is null ) Or (a.end_date_active > sysdate) );
136: Elsif (l_customer_id is not null )Then
137: select resource_id
138: into resource_id
139: from jtf_rs_resource_extns a, fnd_user b
140: where a.source_id = b.customer_id
141: and a.category = 'PARTY'
142: and b.user_id = p_user_id
143: and ( (a.end_date_active is null ) Or (a.end_date_active > sysdate) );

Line 147: from jtf_rs_resource_extns a, fnd_user b

143: and ( (a.end_date_active is null ) Or (a.end_date_active > sysdate) );
144: ElsIf (l_supplier_id is not null )Then
145: select resource_id
146: into resource_id
147: from jtf_rs_resource_extns a, fnd_user b
148: where a.source_id = b.supplier_id
149: and a.category = 'SUPPLIER_CONTACT'
150: and b.user_id = p_user_id
151: and ( (a.end_date_active is null ) Or (a.end_date_active > sysdate) );

Line 502: from jtf_rs_resource_extns a, fnd_user b

498:
499: If (l_employee_id is not null ) Then
500: select resource_id
501: into resource_id
502: from jtf_rs_resource_extns a, fnd_user b
503: where a.source_id = b.employee_id
504: and a.category = 'EMPLOYEE'
505: and b.user_id = l_user_id
506: and ( (a.end_date_active is null ) Or (a.end_date_active > sysdate) );

Line 510: from jtf_rs_resource_extns a, fnd_user b

506: and ( (a.end_date_active is null ) Or (a.end_date_active > sysdate) );
507: Elsif (l_customer_id is not null )Then
508: select resource_id
509: into resource_id
510: from jtf_rs_resource_extns a, fnd_user b
511: where a.source_id = b.customer_id
512: and a.category = 'PARTY'
513: and b.user_id = l_user_id
514: and ( (a.end_date_active is null ) Or (a.end_date_active > sysdate) );

Line 518: from jtf_rs_resource_extns a, fnd_user b

514: and ( (a.end_date_active is null ) Or (a.end_date_active > sysdate) );
515: ElsIf (l_supplier_id is not null )Then
516: select resource_id
517: into resource_id
518: from jtf_rs_resource_extns a, fnd_user b
519: where a.source_id = b.supplier_id
520: and a.category = 'SUPPLIER_CONTACT'
521: and b.user_id = l_user_id
522: and ( (a.end_date_active is null ) Or (a.end_date_active > sysdate) );