APPS.PA_FP_WEBADI_PKG dependencies on PA_PERIOD_MASK_DETAILS

Line 10274: pa_period_mask_details pmd

10270: AND gl.period_type = DECODE(c_time_phased_code,'P',pim.pa_period_type,'G',gsb.accounted_period_type)
10271: AND gl.adjustment_period_flag='N'
10272: AND pim.org_id = c_org_id
10273: AND gsb.set_of_books_id = pim.set_of_books_id)glcp,
10274: pa_period_mask_details pmd
10275: WHERE pmd.period_mask_id = c_prd_mask_id
10276: AND glcp.period_name = c_current_planning_period
10277: AND glsd.rn = pmd.from_anchor_start + glcp.rn
10278: AND gled.rn = pmd.from_anchor_end + glcp.rn

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

11574: x_msg_count OUT NOCOPY NUMBER,
11575: x_msg_data OUT NOCOPY NUMBER)
11576: IS
11577: --This Cursor is used to get Period Mask informations of the Period Mask associated with the budget version.
11578: CURSOR period_mask_cur(c_period_mask_id pa_period_mask_details.period_mask_id%TYPE)
11579: IS
11580: SELECT pmd.period_mask_id,
11581: pmd.num_of_periods,
11582: pmd.anchor_period_flag,

Line 11586: FROM pa_period_mask_details pmd

11582: pmd.anchor_period_flag,
11583: pmd.from_anchor_start,
11584: pmd.from_anchor_end,
11585: pmd.from_anchor_position
11586: FROM pa_period_mask_details pmd
11587: WHERE pmd.period_mask_id = c_period_mask_id
11588: AND pmd.from_anchor_position not in(-99999,99999)
11589: ORDER BY pmd.from_anchor_position;
11590: --PL/SQL table created based on Cursor period_mask_cur.