[Home] [Help]
2989: CURSOR get_asg_hours_freq(cp_date_earned date,
2990: cp_assignment_id number) IS
2991: SELECT hr_general.decode_lookup('FREQUENCY', ASSIGN.frequency)
2992: ,ASSIGN.normal_hours
2993: FROM per_all_assignments_f ASSIGN
2994: where cp_date_earned BETWEEN ASSIGN.effective_start_date
2995: AND ASSIGN.effective_end_date
2996: and ASSIGN.assignment_id = cp_assignment_id
2997: and UPPER(ASSIGN.frequency) = 'W';
3894: CURSOR c_get_res_state_code(p_element_entry_id in number) is
3895: select paf.assignment_id,
3896: pus.state_code
3897: from pay_element_entries_f pee,
3898: per_all_assignments_f paf,
3899: per_all_people_f ppf,
3900: per_addresses pa,
3901: pay_us_states pus
3902: where pee.element_entry_id = p_element_entry_id
3908:
3909: CURSOR c_get_filing_status(p_assignment_id in number) is
3910: select filing_status_code
3911: from pay_us_emp_state_tax_rules_f pestr,
3912: per_all_assignments_f paf,
3913: hr_locations hl,
3914: pay_us_states pus
3915: where pestr.assignment_id = p_assignment_id
3916: and pestr.assignment_id = paf.assignment_id
6025: CURSOR csr_get_filing_status_year is
6026: select ppei.pei_information1
6027: from per_people_extra_info ppei,
6028: pay_element_entries_f peef,
6029: per_all_assignments_f paaf
6030: where peef.element_entry_id = P_CTX_ORIGINAL_ENTRY_ID
6031: and peef.assignment_id = paaf.assignment_id
6032: and paaf.person_id = ppei.person_id
6033: and ppei.information_type = 'US_FED_LEVY_FIL_STATUS_YEAR';