eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_FUNDS_CONTROL_PKG dependencies on PA_BC_BALANCES

Line 3147: -- This CURSOR selects AND sums up all the balances for a particular resource FROM pa_bc_balances table

3143:
3144:
3145:
3146: -----------------------------------------------------------------------------------------------------
3147: -- This CURSOR selects AND sums up all the balances for a particular resource FROM pa_bc_balances table
3148: -- between the start date AND end date RESOURCE CURSOR
3149: -----------------------------------------------------------------------------------------------------
3150: CURSOR res_level_bal (l_rlmi number) is
3151: /* SELECT nvl(sum(BUDGET_PERIOD_TO_DATE * decode(balance_type,'BGT',1,0)) ,0),

Line 3165: FROM pa_bc_balances pb

3161: 0)),0) 7531681 */
3162: SELECT NVL(SUM(BUDGET_PERIOD_TO_DATE ),0),
3163: NVL(SUM(ACTUAL_PERIOD_TO_DATE ),0),
3164: NVL(SUM(ENCUMB_PERIOD_TO_DATE ),0)
3165: FROM pa_bc_balances pb
3166: WHERE pb.project_id = p_record.project_id
3167: /* Bug fix: 3450756 Start */
3168: ---AND pb.task_id = p_record.bud_task_id
3169: AND ( (pb.task_id = p_record.bud_task_id and pb.balance_type in ('BGT'))

Line 3270: -- This CURSOR select the sum of amount from pa bc balances for the given parent

3266: ) );
3267:
3268:
3269: --------------------------------------------------------------------------------------
3270: -- This CURSOR select the sum of amount from pa bc balances for the given parent
3271: -- resource id between the start and end date - RESOURCE GROUP CURSOR
3272: --------------------------------------------------------------------------------------
3273: CURSOR res_grp_level_bal (l_parent_member_id number,l_bud_rlmi number) is
3274: /* SELECT nvl(sum(BUDGET_PERIOD_TO_DATE *decode(balance_type,'BGT',1,0)) ,0),

Line 3289: FROM pa_bc_balances pb

3285:
3286: SELECT NVL(SUM(BUDGET_PERIOD_TO_DATE ),0),
3287: NVL(SUM(ACTUAL_PERIOD_TO_DATE ),0),
3288: NVL(SUM(ENCUMB_PERIOD_TO_DATE ),0)
3289: FROM pa_bc_balances pb
3290: WHERE pb.project_id = p_record.project_id
3291: /* Bug fix: 3450756 Start */
3292: ---AND pb.task_id = p_record.bud_task_id
3293: AND ( (pb.task_id = p_record.bud_task_id and pb.balance_type in ('BGT'))

Line 3353: FROM pa_bc_balances pb

3349: 0)),0) 7531681 */
3350: SELECT NVL(SUM(BUDGET_PERIOD_TO_DATE ),0),
3351: NVL(SUM(ACTUAL_PERIOD_TO_DATE ),0),
3352: NVL(SUM(ENCUMB_PERIOD_TO_DATE ),0)
3353: FROM pa_bc_balances pb
3354: WHERE pb.project_id = p_record.project_id
3355: /* Bug fix: 3450756 Start */
3356: ---AND pb.task_id = p_record.bud_task_id
3357: AND ( (pb.task_id = p_record.bud_task_id and pb.balance_type in ('BGT'))

Line 3454: -- This CURSOR selects AND sums up all the balances for a particular task FROM pa_bc_balances table

3450: )
3451: ));
3452:
3453: -----------------------------------------------------------------------------------------------------
3454: -- This CURSOR selects AND sums up all the balances for a particular task FROM pa_bc_balances table
3455: -- between the start date AND end date and this CURSOR is opened when funds checking rolls up to
3456: -- task level FROM resource level
3457: -----------------------------------------------------------------------------------------------------
3458: CURSOR task_level_bal (l_task_id number)is

Line 3473: FROM pa_bc_balances pb

3469: 0)),0) 7531681 */
3470: SELECT NVL(SUM(BUDGET_PERIOD_TO_DATE ),0),
3471: NVL(SUM(ACTUAL_PERIOD_TO_DATE ),0),
3472: NVL(SUM(ENCUMB_PERIOD_TO_DATE ),0)
3473: FROM pa_bc_balances pb
3474: WHERE pb.project_id = p_record.project_id
3475: AND pb.budget_version_id = p_record.budget_version_id
3476: /* Bug fix: 3450756 Start */
3477: --- AND ( ( pb.task_id = l_task_id AND pb.balance_type='BGT')

Line 3561: -- This CURSOR selects AND sums up all the balances for a particular top task FROM pa_bc_balances table

3557: ) );
3558:
3559:
3560: -----------------------------------------------------------------------------------------------------
3561: -- This CURSOR selects AND sums up all the balances for a particular top task FROM pa_bc_balances table
3562: -- between the start date AND end date
3563: -----------------------------------------------------------------------------------------------------
3564: CURSOR top_task_level_bal (l_bud_task_id number,l_top_task_id number) is
3565: /*SELECT nvl(sum(BUDGET_PERIOD_TO_DATE *decode(balance_type,'BGT',1,0)) ,0),

Line 3579: FROM pa_bc_balances pb

3575: 0)),0) 7531681 */
3576: SELECT NVL(SUM(BUDGET_PERIOD_TO_DATE ),0),
3577: NVL(SUM(ACTUAL_PERIOD_TO_DATE),0),
3578: NVL(SUM(ENCUMB_PERIOD_TO_DATE),0)
3579: FROM pa_bc_balances pb
3580: WHERE pb.project_id = p_record.project_id
3581: AND ((pb.task_id = l_bud_task_id AND pb.balance_type='BGT' AND pb.task_id = l_top_task_id)
3582: OR (pb.top_task_id = l_top_task_id AND pb.balance_type not in ('REV','BGT'))
3583: )

Line 3594: -- This CURSOR selects AND sums up all the balances for a particular task FROM pa_bc_balances table

3590: decode(p_record.time_phased_type_code,'N', pb.end_date, p_end_date_1); -- 7531681
3591:
3592:
3593: -----------------------------------------------------------------------------------------------------
3594: -- This CURSOR selects AND sums up all the balances for a particular task FROM pa_bc_balances table
3595: -- between the start date AND end date and rollup TASKROLLUP CURSOR
3596: -----------------------------------------------------------------------------------------------------
3597: CURSOR task_rollup_bal (l_top_task_id number) is
3598: /* SELECT nvl(sum(BUDGET_PERIOD_TO_DATE *decode(balance_type,'BGT',1,0)) ,0),

Line 3612: FROM pa_bc_balances pb

3608: 0)),0) 7531681 */
3609: SELECT NVL(SUM(BUDGET_PERIOD_TO_DATE ),0),
3610: NVL(SUM(ACTUAL_PERIOD_TO_DATE),0),
3611: NVL(SUM(ENCUMB_PERIOD_TO_DATE ),0)
3612: FROM pa_bc_balances pb
3613: WHERE pb.project_id = p_record.project_id
3614: AND ((pb.top_task_id = l_top_task_id and pb.balance_type not in ('REV','BGT'))
3615: OR (pb.top_task_id = l_top_task_id AND pb.balance_type='BGT'))
3616: AND pb.budget_version_id = p_record.budget_version_id

Line 3671: --This CURSOR selects AND sums up all the balances for a particular project FROM pa_bc_balances table

3667: -- and substr(nvl(pbc.result_code,'P'),1,1)= 'P' -- 7531681
3668: )
3669: ) );
3670: -----------------------------------------------------------------------------------------------------
3671: --This CURSOR selects AND sums up all the balances for a particular project FROM pa_bc_balances table
3672: --between the start date AND end date and this CURSOR is opened when funds checking rolles up to
3673: --the project level FROM task level
3674: -----------------------------------------------------------------------------------------------------
3675: CURSOR project_level_bal is

Line 3690: FROM pa_bc_balances pb

3686: 0)),0) 7531681 */
3687: SELECT NVL(SUM(BUDGET_PERIOD_TO_DATE),0),
3688: NVL(SUM(ACTUAL_PERIOD_TO_DATE ),0),
3689: NVL(SUM(ENCUMB_PERIOD_TO_DATE),0)
3690: FROM pa_bc_balances pb
3691: WHERE pb.project_id = p_record.project_id
3692: AND pb.budget_version_id = p_record.budget_version_id
3693: AND pb.start_date between
3694: decode(p_record.time_phased_type_code,'N', pb.start_date, p_start_date_1) AND -- 7531681

Line 6577: -- to get the resource group level balances from the pa_bc_balances

6573: ---------------------------------------------------------------------------------------
6574: -- api to calulate budgeted resource list id in packet for a budget version,
6575: -- entry level code and budget entry method and update pa_bc_packets for the
6576: -- set of records having the same combinations.The bud_res_list_id is required
6577: -- to get the resource group level balances from the pa_bc_balances
6578: ---------------------------------------------------------------------------------------
6579: FUNCTION bud_res_list_id_update
6580: ( p_project_id IN NUMBER,
6581: p_budget_version_id IN NUMBER,

Line 6591: ---level and get the resource list id from pa_bc_balances

6587:
6588: ----------------------------------------------------------------------------
6589: -- find the correct resource list id for funds checking.
6590: -- if no budget at the resource level then check the budget at the parent
6591: ---level and get the resource list id from pa_bc_balances
6592: ---------------------------------------------------------------------------
6593: CURSOR cur_bud_res_list_id IS
6594: SELECT pr.resource_list_id,
6595: pr.parent_member_id

Line 6605: FROM pa_bc_balances

6601: CURSOR cur_res_member(v_project_id NUMBER,
6602: v_bdgt_version_id NUMBER,
6603: v_res_list_mem_id NUMBER) IS
6604: SELECT resource_list_member_id
6605: FROM pa_bc_balances
6606: WHERE budget_version_id = v_bdgt_version_id
6607: AND project_id = v_project_id
6608: AND resource_list_member_id = v_res_list_mem_id
6609: AND balance_type = 'BGT';

Line 6618: FROM pa_bc_balances

6614: CURSOR cur_parent_res_member(v_project_id NUMBER,
6615: v_bdgt_version_id NUMBER,
6616: v_parent_res_list_mem_id NUMBER) IS
6617: SELECT resource_list_member_id
6618: FROM pa_bc_balances
6619: WHERE budget_version_id = v_bdgt_version_id
6620: ANd project_id = v_project_id
6621: AND resource_list_member_id = v_parent_res_list_mem_id
6622: AND balance_type = 'BGT';

Line 6678: FROM pa_bc_balances pb

6674: BEGIN
6675:
6676: SELECT pb.resource_list_member_id
6677: INTO l_bud_res_list_member_id
6678: FROM pa_bc_balances pb
6679: WHERE pb.budget_version_id = p_budget_version_id
6680: AND pb.project_id = p_project_id
6681: AND balance_type = 'BGT'
6682: AND ROWNUM = 1;

Line 6744: FROM pa_bc_balances

6740: CURSOR cur_low_task_id( l_project_id NUMBER,
6741: l_task_id NUMBER,
6742: l_bdgt_version_id NUMBER) IS
6743: SELECT task_id
6744: FROM pa_bc_balances
6745: WHERE budget_version_id = l_bdgt_version_id
6746: AND project_id = l_project_id
6747: AND task_id = l_task_id
6748: AND balance_type = 'BGT';

Line 6755: FROM pa_bc_balances

6751: CURSOR cur_top_task_id( l_project_id NUMBER,
6752: l_task_id NUMBER,
6753: l_bdgt_version_id NUMBER) IS
6754: SELECT task_id
6755: FROM pa_bc_balances
6756: WHERE budget_version_id = l_bdgt_version_id
6757: AND project_id = l_project_id
6758: AND balance_type = 'BGT'
6759: AND task_id = (SELECT top_task_id

Line 6799: -- (LOW TASK)based on the project,task,budget version from pa_bc_balances if not found then

6795: Elsif p_entry_level_code = 'M' then
6796:
6797: ---------------------------------------------------------------------------------
6798: -- if the budget entry level = 'M' update by record.first select the budget task id
6799: -- (LOW TASK)based on the project,task,budget version from pa_bc_balances if not found then
6800: -- select the budget task id(TOP TASK) based on the project,task,budget version from
6801: -- pa_bc_balacnes for the toptask in pa_tasks
6802: -------------------------------------------------------------------------------------
6803: OPEN cur_low_task_id( p_project_id,

Line 7698: FROM pa_bc_balances gb

7694: -- fail due to a resource mapping error.
7695: -------------------------------------------------------------------------------------
7696: CURSOR get_non_cat_rlmi(v_bdgt_ver_id NUMBER) IS
7697: SELECT resource_list_member_id
7698: FROM pa_bc_balances gb
7699: WHERE gb.budget_version_id = v_bdgt_ver_id
7700: AND balance_type = 'BGT'
7701: AND ROWNUM = 1;
7702: