APPS.PA_PLAN_MATRIX dependencies on PA_BUDGET_LINES_S

Line 452: Pa_Budget_Lines.start_date < p_st_dt_4_st_pd

448: AND Pa_Budget_Lines.TXN_CURRENCY_CODE = main_cur_rec.source_txn_currency_code
449: AND ( Pa_Budget_Lines.Bucketing_period_code = 'PE' -- Bug 2810094. update the SE records where
450: OR -- start_date < period profile start period start date
451: (Pa_Budget_Lines.Bucketing_period_code = 'SE' AND -- with bucketing period code as null
452: Pa_Budget_Lines.start_date < p_st_dt_4_st_pd
453: )
454: );
455: -- Getting the Preceding period start date, end date and period name
456:

Line 584: select pa_budget_lines_s.nextval

580: returning budget_line_id into l_budget_line_id; /* FPB2: MRC */
581:
582: IF SQL%ROWCOUNT = 0 THEN
583:
584: select pa_budget_lines_s.nextval
585: into l_budget_line_id
586: from dual;
587:
588: INSERT INTO PA_BUDGET_LINES

Line 700: WHERE Pa_Budget_Lines.START_DATE < l_st_dt_4_st_pd

696: /* FPB2 : MRC DO NOT ADD AMOUNT COLUMNS TO THE UPDATE OR CONSIDER MRC IMPACT !!! */
697:
698: UPDATE Pa_Budget_Lines
699: SET Bucketing_Period_Code = 'PE'
700: WHERE Pa_Budget_Lines.START_DATE < l_st_dt_4_st_pd
701: AND Pa_Budget_Lines.resource_assignment_id = main_cur_rec.resource_assignment_id
702: AND Pa_Budget_Lines.TXN_CURRENCY_CODE = main_cur_rec.source_txn_currency_code
703: AND Pa_Budget_Lines.Bucketing_period_code IS NULL;
704:

Line 724: AND Pa_Budget_Lines.Start_Date > l_st_dt_4_end_pd

720: AND ( Pa_Budget_Lines.Bucketing_period_code = 'SE' -- Bug 2810094. update the PE records where
721: OR -- start_date > period profile end period start date
722: ( -- with bucketing period code as null
723: Pa_Budget_Lines.Bucketing_period_code = 'PE'
724: AND Pa_Budget_Lines.Start_Date > l_st_dt_4_end_pd
725: )
726: );
727: -- Getting the Succeeding period start date, end date and period name
728:

Line 884: select pa_budget_lines_s.nextval

880: END IF;
881: */
882: ELSE
883: /*IF SQL%ROWCOUNT = 0 THEN*/
884: select pa_budget_lines_s.nextval
885: into l_budget_line_id
886: from dual;
887:
888: INSERT INTO PA_BUDGET_LINES

Line 999: WHERE Pa_Budget_Lines.START_DATE > l_st_dt_4_end_pd

995: -- the end period from the period profile table
996:
997: UPDATE Pa_Budget_Lines
998: SET Bucketing_Period_Code = 'SE'
999: WHERE Pa_Budget_Lines.START_DATE > l_st_dt_4_end_pd
1000: AND Pa_Budget_Lines.resource_assignment_id = main_cur_rec.resource_assignment_id
1001: AND Pa_Budget_Lines.TXN_CURRENCY_CODE = main_cur_rec.source_txn_currency_code
1002: AND Pa_Budget_Lines.Bucketing_period_code IS NULL;
1003: END IF; -- End of if for bucketing period code SD