DBA Data[Home] [Help]

APPS.OZF_AR_SETTLEMENT_PVT dependencies on JTF_RS_RESOURCE_EXTNS

Line 78: from jtf_rs_resource_extns rsc , per_people_f ppl

74: -- Bug4904064: Replaced view jtf_rs_res_emp_vl with direct tables
75: -- Modified for Bugfix 5199354, to reduce shared memory usage further
76: CURSOR c_resource IS
77: select ppl.person_id employee_id
78: from jtf_rs_resource_extns rsc , per_people_f ppl
79: where rsc.category = 'EMPLOYEE' and ppl.person_id = rsc.source_id
80: and trunc(sysdate) between ppl.effective_start_date and ppl.effective_end_date
81: and rsc.resource_id = p_user_id;
82:

Line 1970: , jtf_rs_resource_extns r

1966:
1967: CURSOR csr_salesrep_name(cv_salesrep_id IN NUMBER, cv_org_id IN NUMBER) IS
1968: SELECT nvl(s.name, r.source_name)
1969: FROM jtf_rs_salesreps s
1970: , jtf_rs_resource_extns r
1971: WHERE s.resource_id = r.resource_id
1972: AND s.salesrep_id = cv_salesrep_id
1973: AND s.org_id = cv_org_id;
1974: