APPS.PER_SSHR_CHANGE_PAY dependencies on BEN_PGM_F

Line 39: From Ben_Pgm_f Pgm,

35: and hat.status<>'AC';
36: --
37: Cursor csr_assignment_check Is
38: Select Nvl(Gsp_Allow_Override_Flag,'Y')
39: From Ben_Pgm_f Pgm,
40: Per_all_assignments_F paa
41: Where paa.Assignment_Id = p_assignment_id
42: and p_effective_date between paa.Effective_Start_Date and paa.Effective_End_Date
43: and paa.GRADE_LADDER_PGM_ID is Not NULL

Line 52: From Ben_Pgm_f Pgm

48: and Update_Salary_Cd = 'SALARY_BASIS';
49: --
50: Cursor csr_transaction_check(l_transaction_ladder_id number) Is
51: Select Nvl(Gsp_Allow_Override_Flag,'Y')
52: From Ben_Pgm_f Pgm
53: Where pgm.pgm_id = l_transaction_ladder_id
54: and p_effective_date between Pgm.Effective_Start_Date and Pgm.Effective_End_Date
55: and Pgm_typ_Cd = 'GSP'
56: and Pgm_stat_Cd = 'A'