APPS.CN_PAY_APPROVAL_FLOW_PVT dependencies on CN_PAYRUNS

Line 31: FROM cn_payment_worksheets w,cn_payruns p

27: RAISE FND_API.G_EXC_ERROR;
28: END;
29: BEGIN
30: SELECT p.payrun_id,p.pay_period_id INTO x_payrun_id,x_period_id
31: FROM cn_payment_worksheets w,cn_payruns p
32: WHERE w.payment_worksheet_id = p_worksheet_id
33: AND p.payrun_id = w.payrun_id
34: --R12
35: AND p.org_id = w.org_id

Line 84: p_org_id cn_payruns.org_id%TYPE;

80: AND re1.resource_id = m1.parent_resource_id
81: ;
82:
83: --R12
84: p_org_id cn_payruns.org_id%TYPE;
85: l_has_access BOOLEAN;
86:
87: BEGIN
88:

Line 118: FROM cn_payruns

114:
115: --R12
116: SELECT org_id
117: INTO p_org_id
118: FROM cn_payruns
119: WHERE payrun_id = p_payrun_id;
120:
121: IF cn_payment_security_pvt.is_superuser(p_period_id => p_period_id,p_org_id=>p_org_id) = 1 THEN
122: -- insert record into cn_pay_approval_flow

Line 190: l_payrun_id cn_payruns.payrun_id%TYPE;

186: ) IS
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:

Line 312: l_payrun_id cn_payruns.payrun_id%TYPE;

308: ) IS
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:

Line 439: l_payrun_id cn_payruns.payrun_id%TYPE;

435: ) IS
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: