DBA Data[Home] [Help]

APPS.PAY_SE_STAT_OFFICE_ARCHIVE dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 581: FROM PER_ASSIGNMENT_EXTRA_INFO

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

Line 937: update PER_ASSIGNMENT_EXTRA_INFO

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