DBA Data[Home] [Help]

APPS.PAY_SE_SALARY_STRUCTURE_STATS dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 663: FROM per_assignment_extra_info,

659: /* Assignment level Extra information EIT Details */
660: CURSOR csr_extra_assignment(csr_v_assignment_id per_all_assignments_f.assignment_id%type)
661: IS
662: SELECT hl.meaning
663: FROM per_assignment_extra_info,
664: hr_lookups hl
665: WHERE assignment_id = csr_v_assignment_id --32516 --p_assignment_id
666: AND information_type = 'SE_SALARY_STRUCTURE'
667: AND hl.LOOKUP_TYPE='SE_WORKING_HOUR_TYPE'