APPS.PSB_WS_ACCT2 dependencies on DUAL

Line 556: -- Get GL Balances for a Budget Year by mapping individual Budget Periods in

552: END Map_GL_Balances;
553:
554: /* ----------------------------------------------------------------------- */
555:
556: -- Get GL Balances for a Budget Year by mapping individual Budget Periods in
557: -- the Budget Year to GL Periods
558:
559: PROCEDURE Get_Balances
560: ( p_return_status OUT NOCOPY VARCHAR2,

Line 660: p_dual_posting_type => 'A');

656: p_gl_budget_set_id => p_gl_budget_set_id,
657: p_code_combination_id => p_ccid,
658: p_start_date => p_year_start_date,
659: p_gl_budget_version_id => l_budget_version_id,
660: p_dual_posting_type => 'A');
661:
662: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
663: raise FND_API.G_EXC_ERROR;
664: end if;

Line 2512: FROM dual

2508: -- Bug#3545533: Added
2509: CURSOR l_check_acct_type ( c_code_combination_id NUMBER)
2510: IS
2511: SELECT '1'
2512: FROM dual
2513: WHERE EXISTS
2514: ( SELECT 1
2515: FROM psb_budget_accounts
2516: WHERE code_combination_id = c_code_combination_id

Line 3404: -- Get the individual Segment values for the Code Combination

3400:
3401: end;
3402: end if;
3403:
3404: -- Get the individual Segment values for the Code Combination
3405:
3406: if not FND_FLEX_EXT.Get_Segments
3407: (application_short_name => 'SQLGL',
3408: key_flex_code => 'GL#',

Line 4862: -- Amount is evenly distributed to the individual Period Amounts

4858:
4859:
4860: -- If an Allocation Rule Set has been specified in the WS definition,
4861: -- distribute using the applicable Allocation Rule; otherwise, the YTD
4862: -- Amount is evenly distributed to the individual Period Amounts
4863:
4864:
4865: Distribute_Account_Lines
4866: ( p_return_status => l_return_status,

Line 5062: -- Amount is evenly distributed to the individual Period Amounts

5058:
5059:
5060: -- If an Allocation Rule Set has been specified in the WS definition,
5061: -- distribute using the applicable Allocation Rule; otherwise, the YTD
5062: -- Amount is evenly distributed to the individual Period Amounts
5063:
5064: /* Bug 3352171 start */
5065: -- Comment out the following two lines. The allocation logic will be
5066: -- handled in the PSB_WS_ACCT2.Distribute_Account_Lines function.

Line 5221: -- Amount is evenly distributed to the individual Period Amounts

5217: end if;
5218:
5219: -- If an Allocation Rule Set has been specified in the WS definition,
5220: -- distribute using the applicable Allocation Rule; otherwise, the YTD
5221: -- Amount is evenly distributed to the individual Period Amounts
5222:
5223:
5224: Distribute_Account_Lines
5225: ( p_return_status => l_return_status,

Line 5689: -- Rule Set. All PY balances are extracted from GL by individual periods, all CY

5685:
5686: /* ----------------------------------------------------------------------- */
5687:
5688: -- Distribute YTD Amount using the Allocation Rules specified in the Allocation
5689: -- Rule Set. All PY balances are extracted from GL by individual periods, all CY
5690: -- balances are distributed by the profile specified in the Allocation Rule and
5691: -- all PP balances are distributed by percentages as specified in the Allocation
5692: -- Rule
5693: