APPS.PSP_ADJ_DRIVER dependencies on PSP_ORGANIZATIONS_EXPEND_V

Line 3064: FROM psp_organizations_expend_v

3060:
3061: CURSOR l_exp_org_csr(p_eff_date date, p_exp_org_id Number)
3062: IS
3063: SELECT 'x'
3064: FROM psp_organizations_expend_v
3065: WHERE organization_id = p_exp_org_id
3066: and trunc(p_eff_date) between date_from and nvl(date_to,trunc(p_eff_date));
3067:
3068: l_dummy VARCHAR2(1);

Line 4474: FROM psp_organizations_expend_v

4470:
4471: CURSOR l_exp_org_csr(l_effective_date date)
4472: IS
4473: SELECT 'x'
4474: FROM psp_organizations_expend_v
4475: WHERE organization_id = p_expenditure_org_id
4476: and trunc(l_effective_date) between date_from and nvl(date_to,trunc(l_effective_date));
4477:
4478: l_dummy VARCHAR2(1);