APPS.CN_PAYMENT_SECURITY_PVT dependencies on JTF_RS_RESOURCE_EXTNS

Line 107: l_resource_id jtf_rs_resource_extns.resource_id%TYPE;

103: )
104: RETURN NUMBER
105: IS
106: l_tmp NUMBER := 0;
107: l_resource_id jtf_rs_resource_extns.resource_id%TYPE;
108: BEGIN
109: l_resource_id := NULL;
110:
111: BEGIN

Line 114: FROM jtf_rs_resource_extns

110:
111: BEGIN
112: SELECT resource_id
113: INTO l_resource_id
114: FROM jtf_rs_resource_extns
115: WHERE user_id = fnd_global.user_id;
116: EXCEPTION
117: WHEN NO_DATA_FOUND
118: THEN

Line 180: l_resource_id jtf_rs_resource_extns.resource_id%TYPE;

176: )
177: RETURN NUMBER
178: IS
179: l_tmp NUMBER;
180: l_resource_id jtf_rs_resource_extns.resource_id%TYPE;
181: BEGIN
182: l_resource_id := NULL;
183:
184: BEGIN

Line 187: FROM jtf_rs_resource_extns

183:
184: BEGIN
185: SELECT resource_id
186: INTO l_resource_id
187: FROM jtf_rs_resource_extns
188: WHERE user_id = fnd_global.user_id;
189: EXCEPTION
190: WHEN NO_DATA_FOUND
191: THEN

Line 1052: l_resource_id jtf_rs_resource_extns.resource_id%TYPE;

1048: )
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;

Line 1190: FROM jtf_rs_resource_extns

1186:
1187: BEGIN
1188: SELECT resource_id
1189: INTO l_resource_id
1190: FROM jtf_rs_resource_extns
1191: WHERE user_id = fnd_global.user_id;
1192: EXCEPTION
1193: WHEN NO_DATA_FOUND
1194: THEN

Line 1218: jtf_rs_resource_extns_vl re2,

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
1221: -- get all rows for a login user in jtf_rs_rep_managers
1222: -- with period = p_period_id

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 1724: AND m1.resource_id = ( SELECT resource_id FROM jtf_rs_resource_extns WHERE user_id = p_user_id)

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)
1725: AND ((m1.start_date_active <= pr.end_date) AND (pr.start_date <= Nvl(m1.end_date_active,pr.start_date)))
1726: AND u1.group_id = m1.group_id
1727: AND m1.parent_resource_id = m1.resource_id
1728: AND m1.hierarchy_type IN ('MGR_TO_MGR','REP_TO_REP') AND m1.category <> 'TBH' ) v3