APPS.CN_PAYMENT_SECURITY_PVT dependencies on JTF_RS_GROUP_USAGES

Line 134: jtf_rs_group_usages u1,

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
138: AND pr.org_id=p_org_id

Line 204: jtf_rs_group_usages u1,

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
208: AND pr.org_id=p_org_id

Line 1216: FROM jtf_rs_group_usages u2,

1212: INTO l_tmp
1213: FROM DUAL
1214: WHERE EXISTS (
1215: SELECT 1
1216: FROM jtf_rs_group_usages u2,
1217: jtf_rs_rep_managers m2,
1218: jtf_rs_resource_extns_vl re2,
1219:
1220: -- start inline view

Line 1227: jtf_rs_group_usages u1,

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
1231: AND u1.USAGE = 'COMP_PAYMENT'

Line 1489: FROM jtf_rs_group_usages u2,

1485: INTO l_tmp
1486: FROM DUAL
1487: WHERE EXISTS (
1488: SELECT 1
1489: FROM jtf_rs_group_usages u2,
1490: jtf_rs_rep_managers m2,
1491:
1492: -- start inline view
1493: -- get all rows for a login user in jtf_rs_rep_managers

Line 1499: jtf_rs_group_usages u1,

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
1503: AND u1.USAGE = 'COMP_PAYMENT'

Line 1718: FROM jtf_rs_group_usages u2,jtf_rs_rep_managers m2,jtf_rs_resource_extns_vl re2,

1714: as
1715: ret varchar2(1);
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)

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)