APPS.PSP_ADJ_DRIVER dependencies on PSP_ORGANIZATIONS_EXPEND_V

Line 3055: FROM psp_organizations_expend_v

3051:
3052: CURSOR l_exp_org_csr(p_eff_date date, p_exp_org_id Number)
3053: IS
3054: SELECT 'x'
3055: FROM psp_organizations_expend_v
3056: WHERE organization_id = p_exp_org_id
3057: and trunc(p_eff_date) between date_from and nvl(date_to,trunc(p_eff_date));
3058:
3059: l_dummy VARCHAR2(1);

Line 4465: FROM psp_organizations_expend_v

4461:
4462: CURSOR l_exp_org_csr(l_effective_date date)
4463: IS
4464: SELECT 'x'
4465: FROM psp_organizations_expend_v
4466: WHERE organization_id = p_expenditure_org_id
4467: and trunc(l_effective_date) between date_from and nvl(date_to,trunc(l_effective_date));
4468:
4469: l_dummy VARCHAR2(1);