APPS.PER_SSHR_CHANGE_PAY dependencies on BEN_PGM_F

Line 38: From Ben_Pgm_f Pgm,

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

Line 51: From Ben_Pgm_f Pgm

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