[Home] [Help]
524: from per_all_assignments_f asg1,
525: per_all_assignments_f asg2,
526: per_all_people_f per,
527: pay_element_links_f el,
528: pay_element_types_f et,
529: pay_input_values_f iv1,
530: pay_element_entries_f ee,
531: pay_element_entry_values_f eev1
532: where asg1.assignment_id = p_assignment_id
1090: from per_all_assignments_f asg1,
1091: per_all_assignments_f asg2,
1092: per_all_people_f per,
1093: pay_element_links_f el,
1094: pay_element_types_f et,
1095: pay_input_values_f iv1,
1096: pay_element_entries_f ee,
1097: pay_element_entry_values_f eev1
1098: where asg1.assignment_id = p_assignment_id
1123: from per_all_assignments_f asg1,
1124: per_all_assignments_f asg2,
1125: per_all_people_f per,
1126: pay_element_links_f el,
1127: pay_element_types_f et,
1128: pay_input_values_f iv1,
1129: pay_element_entries_f ee,
1130: pay_element_entry_values_f eev1
1131: where asg1.assignment_id = p_assignment_id
1152: cursor csr_get_benefit_type (
1153: p_assignment_id per_all_assignments_f.assignment_id%type
1154: ) is
1155: select pat.element_type_id, pat.element_name, pat.element_information1 benefit_type_code
1156: from pay_element_classifications pec, pay_element_types_f pat, pay_element_entries_f pet
1157: where pec.classification_name = 'Benefits in Kind'
1158: and pec.legislation_code = 'FI'
1159: and (pat.legislation_code = 'FI' or pat.business_group_id = g_business_group_id)
1160: and pec.classification_id = pat.classification_id
1262: l_pay_period_start_date pay_action_information.action_information5%type;
1263: l_pay_period_end_date pay_action_information.action_information3%type;
1264: l_period_type pay_action_information.action_information3%type;
1265: l_run_assignment_action_id number;
1266: -- l_benefit_type_code pay_element_types_f.element_information1%type;
1267: l_benefit_type varchar2 (200);
1268: l_benefit_monetary_value number;
1269: l_sal_sub_to_tax number;
1270: l_tax_at_source number;