DBA Data[Home] [Help]

APPS.PAY_SE_STAT_OFFICE_ARCHIVE dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 582: FROM PER_ASSIGNMENT_EXTRA_INFO

578: fnd_date.canonical_to_date(AEI_INFORMATION1) start_date,
579: fnd_date.canonical_to_date(AEI_INFORMATION2) end_date,
580: AEI_INFORMATION3 full_day,
581: AEI_INFORMATION4 part_day
582: FROM PER_ASSIGNMENT_EXTRA_INFO
583: WHERE assignment_id=p_assignment_id
584: AND aei_information_category ='SE_SICKNESS_CORRECTION_DATA'
585: AND aei_information5='Y';
586:

Line 938: update PER_ASSIGNMENT_EXTRA_INFO

934: p_action_information20=> NULL
935: );
936:
937:
938: update PER_ASSIGNMENT_EXTRA_INFO
939: set aei_information5='N'
940: where assignment_extra_info_id = l_csr_correction_data.assignment_extra_info_id;
941: END IF;
942: