APPS.CN_PAYMENT_SECURITY_PVT dependencies on CN_PERIOD_STATUSES

Line 133: FROM cn_period_statuses pr,

129: -- check if user is in analyst hierarchy in this period,
130: -- if view empty, not exist and not a super user, l_tmp will become NULL
131: (SELECT m1.parent_resource_id,
132: m1.resource_id
133: FROM cn_period_statuses pr,
134: jtf_rs_group_usages u1,
135: jtf_rs_rep_managers m1
136: WHERE p_period_id IS NOT NULL
137: AND pr.period_id = p_period_id

Line 203: FROM cn_period_statuses pr,

199: INTO l_tmp
200: FROM DUAL
201: WHERE EXISTS (
202: SELECT 1
203: FROM cn_period_statuses pr,
204: jtf_rs_group_usages u1,
205: jtf_rs_rep_managers m1
206: WHERE p_period_id IS NOT NULL
207: AND pr.period_id = p_period_id

Line 706: l_period_id cn_period_statuses.period_id%TYPE;

702: )
703: IS
704: l_api_name CONSTANT VARCHAR2 (30) := 'Payrun_Action';
705: l_api_version CONSTANT NUMBER := 1.0;
706: l_period_id cn_period_statuses.period_id%TYPE;
707: l_payrun_status cn_payruns.status%TYPE;
708: l_tmp NUMBER;
709: l_temp NUMBER ;
710:

Line 1053: l_period_id cn_period_statuses.period_id%TYPE;

1049: IS
1050: l_api_name CONSTANT VARCHAR2 (30) := 'Worksheet_action';
1051: l_api_version CONSTANT NUMBER := 1.0;
1052: l_resource_id jtf_rs_resource_extns.resource_id%TYPE;
1053: l_period_id cn_period_statuses.period_id%TYPE;
1054: l_worksheet_rec cn_payment_worksheets%ROWTYPE;
1055: l_payrun_status cn_payruns.status%TYPE;
1056: l_pay_period_id cn_payruns.pay_period_id%TYPE;
1057: l_assigned_to_user_id cn_salesreps.assigned_to_user_id%TYPE := NULL;

Line 1226: FROM cn_period_statuses pr,

1222: -- with period = p_period_id
1223: (SELECT DISTINCT m1.resource_id,
1224: GREATEST (pr.start_date, m1.start_date_active) start_date,
1225: LEAST (pr.end_date, NVL (m1.end_date_active, pr.end_date)) end_date
1226: FROM cn_period_statuses pr,
1227: jtf_rs_group_usages u1,
1228: jtf_rs_rep_managers m1
1229: WHERE pr.period_id = l_pay_period_id
1230: AND pr.org_id=l_org_id

Line 1498: FROM cn_period_statuses pr,

1494: -- with period = p_period_id
1495: (SELECT DISTINCT m1.resource_id,
1496: GREATEST (pr.start_date, m1.start_date_active) start_date,
1497: LEAST (pr.end_date, NVL (m1.end_date_active, pr.end_date)) end_date
1498: FROM cn_period_statuses pr,
1499: jtf_rs_group_usages u1,
1500: jtf_rs_rep_managers m1
1501: WHERE pr.period_id = l_pay_period_id
1502: AND pr.org_id=l_org_id

Line 1720: FROM cn_period_statuses pr,jtf_rs_group_usages u1, jtf_rs_rep_managers m1

1716: begin
1717: SELECT DECODE( (SELECT 1 FROM dual WHERE EXISTS ( SELECT 1
1718: FROM jtf_rs_group_usages u2,jtf_rs_rep_managers m2,jtf_rs_resource_extns_vl re2,
1719: (SELECT DISTINCT m1.resource_id, GREATEST(pr.start_date,m1.start_date_active) start_date,LEAST(pr.end_date,Nvl(m1.end_date_active,pr.end_date)) end_date
1720: FROM cn_period_statuses pr,jtf_rs_group_usages u1, jtf_rs_rep_managers m1
1721: WHERE pr.period_id = (SELECT p1.pay_period_id FROM cn_payruns p1 WHERE p1.payrun_id = p_payrun_id)
1722: AND pr.org_id =(SELECT org_id FROM cn_payruns where payrun_id=p_payrun_id)
1723: AND u1.usage = 'COMP_PAYMENT'
1724: AND m1.resource_id = ( SELECT resource_id FROM jtf_rs_resource_extns WHERE user_id = p_user_id)