[Home] [Help]
196: END;
197:
198: SELECT 1
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,
921: -- all worksheet should be 'APPROVED' if profile = 'Y'
922: BEGIN
923: SELECT 1
924: INTO l_tmp
925: FROM DUAL
926: WHERE EXISTS (SELECT 1
927: FROM cn_payment_worksheets
928: WHERE payrun_id = p_payrun_id AND worksheet_status <> 'APPROVED');
929:
1209: ELSE
1210: BEGIN
1211: SELECT 1
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,
1482: ELSE
1483: BEGIN
1484: SELECT 1
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,
1713: FUNCTION getDataAccess(p_payrun_id in number,p_assigned_to_user_id in number,p_user_id in number) return varchar2
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)
1733: AND m2.hierarchy_type IN ('MGR_TO_MGR','MGR_TO_REP','REP_TO_REP')
1734: AND m2.resource_id = re2.resource_id
1735: AND re2.user_id = Nvl(p_assigned_to_user_id,re2.user_id))) ,1,'Y',NULL,'N','N')
1736: into ret
1737: from dual;
1738: return nvl(ret,'N');
1739: end getDataAccess;
1740:
1741:
1750: l_dret :=getDataAccess(p_payrun_id,p_assigned_to_user_id,p_user_id);
1751: l_sret :=getPermission('CN_PMT_WKSHT_VIEW');
1752:
1753:
1754: select decode(l_dret,l_sret,decode(l_dret,'Y','Y','N'),'N') into l_sret from dual;
1755: return l_sret;
1756:
1757: EXCEPTION
1758: WHEN OTHERS