APPS.PSP_PEE_BUS dependencies on GMS_AWARDS_ALL

Line 803: FROM gms_awards_all

799: l_award_id NUMBER;
800: --
801: CURSOR award_id_csr(p_award_id IN NUMBER, p_distribution_date IN DATE) IS
802: SELECT award_id
803: FROM gms_awards_all
804: WHERE award_id = p_award_id
805: 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'));
806: BEGIN
807: --

Line 1044: FROM gms_awards_all

1040: AND p_distribution_date between nvl(start_date,trunc(p_distribution_date)) and nvl(completion_date,to_date('31/12/4712','DD/MM/RRRR'));
1041:
1042: CURSOR award_csr(p_award_id IN NUMBER, p_distribution_date IN DATE) IS
1043: SELECT award_id
1044: FROM gms_awards_all
1045: WHERE award_id = p_award_id
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