132: l_chk_grp_party_id per_people_f.party_id%type := null;
133: l_ssn per_people_f.national_identifier%type := null;
134: l_assignment_id per_assignments_f.assignment_id%type;
135: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;
136: l_element_type_id pay_element_types_f.element_type_id%type;
137: l_tax_unit_id pay_assignment_actions.tax_unit_id%type;
138: l_payroll_id pay_payroll_actions.payroll_id%type;
139:
140: l_proc_name constant varchar2(150):= g_pkg||'Transfer_Student_Earnings';
276: where petr.element_set_id = :4
277: and petr.include_or_exclude = ''I''
278: union all
279: select distinct pet1.element_type_id
280: from pay_element_types_f pet1
281: where pet1.classification_id in
282: (select classification_id
283: from pay_ele_classification_rules
284: where element_set_id = :5)
409: where petr.element_set_id = ' || p_element_set_id || '
410: and petr.include_or_exclude = ''I''
411: union all
412: select distinct pet1.element_type_id
413: from pay_element_types_f pet1
414: where pet1.classification_id in
415: (select classification_id
416: from pay_ele_classification_rules
417: where element_set_id = ' || p_element_set_id || ')
510: where petr.element_set_id = :4
511: and petr.include_or_exclude = ''I''
512: union all
513: select distinct pet1.element_type_id
514: from pay_element_types_f pet1
515: where pet1.classification_id in
516: (select classification_id
517: from pay_ele_classification_rules
518: where element_set_id = :5)
616: where petr.element_set_id = :4
617: and petr.include_or_exclude = ''I''
618: union all
619: select distinct pet1.element_type_id
620: from pay_element_types_f pet1
621: where pet1.classification_id in
622: (select classification_id
623: from pay_ele_classification_rules
624: where element_set_id = :5)