[Home] [Help]
382: -- Cursor to check already archived assignment
383: /*CURSOR csr_already_archived (p_assg_id number) IS
384: SELECT nvl(peev.screen_entry_value,'N')
385: FROM pay_element_types_f pet,
386: pay_input_values_f piv,
387: pay_element_entries_f pee,
388: pay_element_entry_values_f peev,
389: per_all_assignments_f paa
390: WHERE pet.element_name='IE P45P3_P46 Information'
423: --cursor to check the file type(P45/P46) of the assignment
424: CURSOR csr_scr_ent_val(c_asg_id IN Number,c_element_name in varchar2) IS
425: SELECT peev.screen_entry_value P45P3_P46_Processed
426: FROM pay_element_types_f pet,
427: pay_input_values_f piv,
428: pay_element_entries_f pee,
429: pay_element_entry_values_f peev
430: WHERE pet.element_name = 'IE P45P3_P46 Information'
431: and piv.name =c_element_name
792: IS
793: CURSOR csr_get_assg_detail(passactid IN NUMBER)IS
794: SELECT piv.name input_name,peev.screen_entry_value input_value
795: FROM pay_element_types_f pet,
796: pay_input_values_f piv,
797: pay_element_entries_f pee,
798: pay_element_entry_values_f peev,
799: per_all_assignments_f paa,
800: pay_assignment_actions paac
855: from per_all_assignments_f paa1
856: where paa1.assignment_id = paa.assignment_id
857: and paa1.effective_start_date between g_start_date and g_end_date );
858:
859: TYPE r_get_assg_detail IS RECORD (i_name pay_input_values_f.name%type,
860: i_value pay_element_entry_values_f.screen_entry_value%type);
861: TYPE t_get_assg_detail IS TABLE OF r_get_assg_detail INDEX BY Binary_Integer;
862: /*
863: CURSOR csr_archive_processed(passactid IN NUMBER) IS
862: /*
863: CURSOR csr_archive_processed(passactid IN NUMBER) IS
864: SELECT peev.screen_entry_value
865: from pay_element_types_f pet,
866: pay_input_values_f piv,
867: pay_element_entries_f pee,
868: pay_element_entry_values_f peev,
869: per_all_assignments_f paa,
870: pay_assignment_actions paac