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