APPS.CN_PAY_APPROVAL_FLOW_PVT dependencies on JTF_RS_RESOURCE_EXTNS

Line 20: FROM jtf_rs_resource_extns

16:
17: BEGIN
18: BEGIN
19: SELECT resource_id,source_email INTO x_resource_id,x_user_email
20: FROM jtf_rs_resource_extns
21: WHERE user_id = fnd_global.user_id;
22: EXCEPTION
23: WHEN no_data_found THEN
24: -- resource not exist for this user

Line 68: jtf_rs_resource_extns re1

64: SELECT DISTINCT m1.parent_resource_id mgr_resource_id,
65: re1.source_email mgr_email,re1.user_id mgr_user_id
66: FROM cn_period_statuses pr,
67: jtf_rs_group_usages u1, jtf_rs_rep_managers m1,
68: jtf_rs_resource_extns re1
69: WHERE pr.period_id = p_period_id
70: AND pr.org_id = c_org_id
71: AND u1.usage = 'COMP_PAYMENT'
72: AND m1.resource_id = p_resource_id

Line 191: l_resource_id jtf_rs_resource_extns.resource_id%TYPE;

187: l_api_name CONSTANT VARCHAR2(30) := 'Submit_Worksheet';
188: l_api_version CONSTANT NUMBER := 1.0;
189:
190: l_payrun_id cn_payruns.payrun_id%TYPE;
191: l_resource_id jtf_rs_resource_extns.resource_id%TYPE;
192: l_period_id cn_period_statuses.period_id%TYPE;
193: l_user_email jtf_rs_resource_extns.source_email%TYPE;
194:
195: l_has_access BOOLEAN;

Line 193: l_user_email jtf_rs_resource_extns.source_email%TYPE;

189:
190: l_payrun_id cn_payruns.payrun_id%TYPE;
191: l_resource_id jtf_rs_resource_extns.resource_id%TYPE;
192: l_period_id cn_period_statuses.period_id%TYPE;
193: l_user_email jtf_rs_resource_extns.source_email%TYPE;
194:
195: l_has_access BOOLEAN;
196:
197: BEGIN

Line 313: l_resource_id jtf_rs_resource_extns.resource_id%TYPE;

309: l_api_name CONSTANT VARCHAR2(30) := 'Approve_Worksheet';
310: l_api_version CONSTANT NUMBER := 1.0;
311:
312: l_payrun_id cn_payruns.payrun_id%TYPE;
313: l_resource_id jtf_rs_resource_extns.resource_id%TYPE;
314: l_period_id cn_period_statuses.period_id%TYPE;
315: l_user_email jtf_rs_resource_extns.source_email%TYPE;
316:
317: l_has_access BOOLEAN;

Line 315: l_user_email jtf_rs_resource_extns.source_email%TYPE;

311:
312: l_payrun_id cn_payruns.payrun_id%TYPE;
313: l_resource_id jtf_rs_resource_extns.resource_id%TYPE;
314: l_period_id cn_period_statuses.period_id%TYPE;
315: l_user_email jtf_rs_resource_extns.source_email%TYPE;
316:
317: l_has_access BOOLEAN;
318:
319: BEGIN

Line 440: l_resource_id jtf_rs_resource_extns.resource_id%TYPE;

436: l_api_name CONSTANT VARCHAR2(30) := 'Reject_Worksheet';
437: l_api_version CONSTANT NUMBER := 1.0;
438:
439: l_payrun_id cn_payruns.payrun_id%TYPE;
440: l_resource_id jtf_rs_resource_extns.resource_id%TYPE;
441: l_period_id cn_period_statuses.period_id%TYPE;
442: l_user_email jtf_rs_resource_extns.source_email%TYPE;
443:
444: l_has_access BOOLEAN;

Line 442: l_user_email jtf_rs_resource_extns.source_email%TYPE;

438:
439: l_payrun_id cn_payruns.payrun_id%TYPE;
440: l_resource_id jtf_rs_resource_extns.resource_id%TYPE;
441: l_period_id cn_period_statuses.period_id%TYPE;
442: l_user_email jtf_rs_resource_extns.source_email%TYPE;
443:
444: l_has_access BOOLEAN;
445:
446: BEGIN