APPS.PA_FP_WEBADI_PKG dependencies on PA_PERIOD_MASK_DETAILS

Line 10455: pa_period_mask_details pmd

10451: AND gl.period_type = DECODE(c_time_phased_code,'P',pim.pa_period_type,'G',gsb.accounted_period_type)
10452: AND gl.adjustment_period_flag='N'
10453: AND pim.org_id = c_org_id
10454: AND gsb.set_of_books_id = pim.set_of_books_id)glcp,
10455: pa_period_mask_details pmd
10456: WHERE pmd.period_mask_id = c_prd_mask_id
10457: AND glcp.period_name = c_current_planning_period
10458: AND glsd.rn = pmd.from_anchor_start + glcp.rn
10459: AND gled.rn = pmd.from_anchor_end + glcp.rn

Line 11809: CURSOR period_mask_cur(c_period_mask_id pa_period_mask_details.period_mask_id%TYPE)

11805: x_msg_count OUT NOCOPY NUMBER,
11806: x_msg_data OUT NOCOPY NUMBER)
11807: IS
11808: --This Cursor is used to get Period Mask informations of the Period Mask associated with the budget version.
11809: CURSOR period_mask_cur(c_period_mask_id pa_period_mask_details.period_mask_id%TYPE)
11810: IS
11811: SELECT pmd.period_mask_id,
11812: pmd.num_of_periods,
11813: pmd.anchor_period_flag,

Line 11817: FROM pa_period_mask_details pmd

11813: pmd.anchor_period_flag,
11814: pmd.from_anchor_start,
11815: pmd.from_anchor_end,
11816: pmd.from_anchor_position
11817: FROM pa_period_mask_details pmd
11818: WHERE pmd.period_mask_id = c_period_mask_id
11819: AND pmd.from_anchor_position not in(-99999,99999)
11820: ORDER BY pmd.from_anchor_position;
11821: --PL/SQL table created based on Cursor period_mask_cur.