APPS.PSP_PEE_BUS dependencies on PSP_ORGANIZATIONS_EXPEND_V

Line 854: FROM psp_organizations_expend_v

850:
851: --
852: CURSOR expenditure_organization_csr(p_expenditure_organization_id IN NUMBER, p_distribution_date IN DATE) IS
853: SELECT organization_id
854: FROM psp_organizations_expend_v
855: WHERE organization_id = p_expenditure_organization_id
856: AND trunc(p_distribution_date) between date_from and nvl(date_to,trunc(p_distribution_date));
857: BEGIN
858: --

Line 1050: FROM psp_organizations_expend_v

1046: AND p_distribution_date between nvl(start_date_active,trunc(p_distribution_date)) and nvl(end_date_active,to_date('31/12/4712','DD/MM/RRRR'));
1047:
1048: CURSOR expenditure_organization_csr(p_expenditure_organization_id IN NUMBER, p_distribution_date IN DATE) IS
1049: SELECT organization_id
1050: FROM psp_organizations_expend_v
1051: WHERE organization_id = p_expenditure_organization_id
1052: AND trunc(p_distribution_date) between date_from and nvl(date_to,trunc(p_distribution_date));
1053:
1054: --