APPS.CN_PAY_APPROVAL_FLOW_PVT dependencies on CN_PERIOD_STATUSES

Line 66: FROM cn_period_statuses pr,

62:
63: CURSOR c_mgr_csr(c_org_id NUMBER) IS
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

Line 192: l_period_id cn_period_statuses.period_id%TYPE;

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;
196:

Line 314: l_period_id cn_period_statuses.period_id%TYPE;

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;
318:

Line 441: l_period_id cn_period_statuses.period_id%TYPE;

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;
445: