APPS.PSB_BUDGET_PERIOD_PVT dependencies on PSB_BUDGET_YEAR_TYPES

Line 1013: psb_budget_year_types b,

1009: --
1010: CURSOR prior_year_csr IS
1011: SELECT max(b.sequence_number), end_date
1012: FROM psb_budget_periods a,
1013: psb_budget_year_types b,
1014: psb_budget_year_types c
1015: WHERE a.budget_year_type_id = b.budget_year_type_id
1016: AND b.sequence_number < c.sequence_number
1017: AND c.budget_year_type_id = p_curr_year_type

Line 1014: psb_budget_year_types c

1010: CURSOR prior_year_csr IS
1011: SELECT max(b.sequence_number), end_date
1012: FROM psb_budget_periods a,
1013: psb_budget_year_types b,
1014: psb_budget_year_types c
1015: WHERE a.budget_year_type_id = b.budget_year_type_id
1016: AND b.sequence_number < c.sequence_number
1017: AND c.budget_year_type_id = p_curr_year_type
1018: AND a.budget_calendar_id = p_calendar_id

Line 1025: psb_budget_year_types b,

1021: --
1022: CURSOR next_year_csr IS
1023: SELECT min(b.sequence_number), start_date
1024: FROM psb_budget_periods a,
1025: psb_budget_year_types b,
1026: psb_budget_year_types c
1027: WHERE a.budget_year_type_id = b.budget_year_type_id
1028: AND b.sequence_number > c.sequence_number
1029: AND c.budget_year_type_id = p_curr_year_type

Line 1026: psb_budget_year_types c

1022: CURSOR next_year_csr IS
1023: SELECT min(b.sequence_number), start_date
1024: FROM psb_budget_periods a,
1025: psb_budget_year_types b,
1026: psb_budget_year_types c
1027: WHERE a.budget_year_type_id = b.budget_year_type_id
1028: AND b.sequence_number > c.sequence_number
1029: AND c.budget_year_type_id = p_curr_year_type
1030: AND a.budget_calendar_id = p_calendar_id

Line 1035: FROM psb_budget_year_types a,

1031: GROUP BY start_date ;
1032: --
1033: CURSOR prior_type_csr IS
1034: SELECT max(a.sequence_number)
1035: FROM psb_budget_year_types a,
1036: psb_budget_year_types b
1037: WHERE a.sequence_number < b.sequence_number
1038: AND b.budget_year_type_id = p_curr_year_type;
1039: --

Line 1036: psb_budget_year_types b

1032: --
1033: CURSOR prior_type_csr IS
1034: SELECT max(a.sequence_number)
1035: FROM psb_budget_year_types a,
1036: psb_budget_year_types b
1037: WHERE a.sequence_number < b.sequence_number
1038: AND b.budget_year_type_id = p_curr_year_type;
1039: --
1040: CURSOR next_type_csr IS

Line 1042: FROM psb_budget_year_types a,

1038: AND b.budget_year_type_id = p_curr_year_type;
1039: --
1040: CURSOR next_type_csr IS
1041: SELECT min(a.sequence_number)
1042: FROM psb_budget_year_types a,
1043: psb_budget_year_types b
1044: WHERE a.sequence_number > b.sequence_number
1045: AND b.budget_year_type_id = p_curr_year_type;
1046: --

Line 1043: psb_budget_year_types b

1039: --
1040: CURSOR next_type_csr IS
1041: SELECT min(a.sequence_number)
1042: FROM psb_budget_year_types a,
1043: psb_budget_year_types b
1044: WHERE a.sequence_number > b.sequence_number
1045: AND b.budget_year_type_id = p_curr_year_type;
1046: --
1047: BEGIN

Line 1541: psb_budget_year_types b

1537: a.attribute10,
1538: a.context,
1539: b.year_category_type
1540: FROM psb_budget_periods a,
1541: psb_budget_year_types b
1542: WHERE budget_calendar_id = p_source_cal_id
1543: AND a.budget_year_type_id = b.budget_year_type_id
1544: ORDER BY start_date;
1545: --

Line 1549: FROM psb_budget_year_types a,

1545: --
1546: l_prev_year_type_id NUMBER ;
1547: CURSOR prev_type_csr IS
1548: SELECT a.year_category_type,a.budget_year_type_id
1549: FROM psb_budget_year_types a,
1550: psb_budget_year_types b
1551: WHERE a.sequence_number < b.sequence_number
1552: AND b.budget_year_type_id = l_prev_year_type_id
1553: ORDER BY a.sequence_number DESC;

Line 1550: psb_budget_year_types b

1546: l_prev_year_type_id NUMBER ;
1547: CURSOR prev_type_csr IS
1548: SELECT a.year_category_type,a.budget_year_type_id
1549: FROM psb_budget_year_types a,
1550: psb_budget_year_types b
1551: WHERE a.sequence_number < b.sequence_number
1552: AND b.budget_year_type_id = l_prev_year_type_id
1553: ORDER BY a.sequence_number DESC;
1554: --