APPS.PSB_POSITION_CONTROL_PVT dependencies on PSB_POSITION_PAY_DISTR_S

Line 2452: SELECT PSB_POSITION_PAY_DISTR_S.NEXTVAL

2448: -- them and populate them into record type.
2449: IF rec_end_date(i) IS NULL THEN
2450: IF rec_start_date(i) < l_year_start_date THEN
2451:
2452: SELECT PSB_POSITION_PAY_DISTR_S.NEXTVAL
2453: INTO l_distribution_id
2454: FROM dual;
2455:
2456: l_count_ins_rec := l_count_ins_rec + 1;

Line 2484: /*SELECT PSB_POSITION_PAY_DISTR_S.NEXTVAL

2480: := rec_cost_alloc_key_flex_id(i);
2481: ins_description(l_count_ins_rec) := rec_description(i);
2482: END IF;
2483:
2484: /*SELECT PSB_POSITION_PAY_DISTR_S.NEXTVAL
2485: INTO l_distribution_id
2486: FROM dual;
2487:
2488: l_count_ins_rec := l_count_ins_rec + 1;

Line 2519: SELECT PSB_POSITION_PAY_DISTR_S.NEXTVAL

2515: -- If distribution is end dated
2516: ELSE
2517: IF rec_start_date(i) < l_year_start_date THEN
2518:
2519: SELECT PSB_POSITION_PAY_DISTR_S.NEXTVAL
2520: INTO l_distribution_id
2521: FROM dual;
2522:
2523: l_count_ins_rec := l_count_ins_rec + 1;

Line 2552: SELECT PSB_POSITION_PAY_DISTR_S.NEXTVAL

2548: ins_description(l_count_ins_rec) := rec_description(i);
2549:
2550: IF rec_end_date(i) > l_year_end_date THEN
2551:
2552: SELECT PSB_POSITION_PAY_DISTR_S.NEXTVAL
2553: INTO l_distribution_id
2554: FROM dual;
2555:
2556: l_count_ins_rec := l_count_ins_rec + 1;

Line 2590: SELECT PSB_POSITION_PAY_DISTR_S.NEXTVAL

2586: -- not between upload start date and end date. If so, then do
2587: -- nothing. These records will automatically be deleted.
2588: IF rec_end_date(i) > l_year_end_Date THEN
2589:
2590: SELECT PSB_POSITION_PAY_DISTR_S.NEXTVAL
2591: INTO l_distribution_id
2592: FROM dual;
2593:
2594: l_count_ins_rec := l_count_ins_rec + 1;

Line 2768: SELECT PSB_POSITION_PAY_DISTR_S.NEXTVAL

2764: /*IF l_distr_start_date = l_pos_start_date
2765: AND
2766: p_position_exists = FALSE
2767: THEN
2768: SELECT PSB_POSITION_PAY_DISTR_S.NEXTVAL
2769: INTO l_distribution_id
2770: FROM dual;
2771:
2772: l_count_ins_rec := l_count_ins_rec + 1;

Line 2839: SELECT PSB_POSITION_PAY_DISTR_S.NEXTVAL

2835: END IF;
2836:
2837: IF(l_budget_year_end_date <= l_distr_end_date) THEN
2838:
2839: SELECT PSB_POSITION_PAY_DISTR_S.NEXTVAL
2840: INTO l_distribution_id
2841: FROM dual;
2842: l_count_ins_rec := l_count_ins_rec + 1;
2843: ins_distribution_id(l_count_ins_rec) := l_distribution_id;

Line 2857: SELECT PSB_POSITION_PAY_DISTR_S.NEXTVAL

2853: l_date_val := l_budget_year_end_date + 1;
2854:
2855: -- Insert the end dated distribution
2856: ELSE
2857: SELECT PSB_POSITION_PAY_DISTR_S.NEXTVAL
2858: INTO l_distribution_id
2859: FROM dual;
2860:
2861: l_count_ins_rec := l_count_ins_rec + 1;

Line 2917: SELECT PSB_POSITION_PAY_DISTR_S.NEXTVAL

2913: /* Bug 4060926 End */
2914: RAISE FND_API.G_EXC_ERROR;
2915: END IF;
2916:
2917: SELECT PSB_POSITION_PAY_DISTR_S.NEXTVAL
2918: INTO l_distribution_id
2919: FROM dual;
2920: l_count_ins_rec := l_count_ins_rec + 1;
2921: ins_distribution_id(l_count_ins_rec) := l_distribution_id;

Line 2937: SELECT PSB_POSITION_PAY_DISTR_S.NEXTVAL

2933: END LOOP;
2934:
2935: /*-- Populate the PL/SQL table with a non end dated record
2936: -- for the open ws record.
2937: SELECT PSB_POSITION_PAY_DISTR_S.NEXTVAL
2938: INTO l_distribution_id
2939: FROM dual;
2940:
2941: l_count_ins_rec := l_count_ins_rec + 1;

Line 3226: select PSB_POSITION_PAY_DISTR_S.NEXTVAL seq

3222: select PSB_POSITION_ASSIGNMENTS_S.NEXTVAL seq
3223: from dual;
3224:
3225: cursor c_posdistr_seq is
3226: select PSB_POSITION_PAY_DISTR_S.NEXTVAL seq
3227: from dual;
3228:
3229: BEGIN
3230: