APPS.PA_FP_PERIOD_MASKS_UTILS dependencies on PA_PERIOD_MASKS_TL

Line 10: (p_name IN pa_period_masks_tl.name%TYPE,

6: **********************************************************************/
7: P_PA_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
8:
9: PROCEDURE NAME_VALIDATION
10: (p_name IN pa_period_masks_tl.name%TYPE,
11: p_period_mask_id IN pa_period_masks_b.period_mask_id%TYPE,
12: p_init_msg_flag IN VARCHAR2,
13: x_return_status OUT NOCOPY VARCHAR2,
14: x_msg_count OUT NOCOPY NUMBER,

Line 38: FROM pa_period_masks_tl

34: x_msg_count := 0;
35: BEGIN
36: SELECT 'Y'
37: INTO l_exists
38: FROM pa_period_masks_tl
39: WHERE UPPER(name) = UPPER(p_name)
40: AND p_period_mask_id <> period_mask_id
41: AND ROWNUM < 2;
42: --DBMS_OUTPUT.PUT_LINE(p_name || ' Already Exists');