DBA Data[Home] [Help]

APPS.PER_SALADMIN_UTILITY dependencies on BEN_PGM_F

Line 10: From Ben_Pgm_f Pgm,

6:
7: function Check_GSP_Manual_Override (p_assignment_id in NUMBER, p_effective_date in DATE) RETURN VARCHAR2 is
8: Cursor Grade_Ladder Is
9: Select Nvl(Gsp_Allow_Override_Flag,'Y')
10: From Ben_Pgm_f Pgm,
11: Per_all_assignments_F paa
12: Where paa.Assignment_Id = p_assignment_id
13: and p_effective_date between paa.Effective_Start_Date and paa.Effective_End_Date
14: and paa.GRADE_LADDER_PGM_ID is Not NULL

Line 764: from ben_pgm_f pgm

760: is
761:
762: cursor csr_lookup is
763: select name
764: from ben_pgm_f pgm
765: where pgm_id = p_grade_ladder_id
766: and p_effective_date between
767: pgm.effective_start_date and pgm.effective_end_date;
768: