APPS.PAY_US_SQWL_UDF dependencies on PER_ALL_ASSIGNMENTS_F

Line 529: from per_all_assignments_f

525: ) RETURN varchar2 IS
526:
527: CURSOR get_person_id IS
528: select distinct person_id
529: from per_all_assignments_f
530: where assignment_id = p_assignment_id;
531:
532: /* Added for Bug#9561700*/
533: /*Since we are using the Date Based approach to fetch the Balances

Line 543: from per_all_assignments_f asg,

539:
540: CURSOR get_effective_date (p_quarter_start_date DATE,
541: p_quarter_end_date DATE) IS
542: select max(ppa.effective_date)
543: from per_all_assignments_f asg,
544: pay_assignment_actions paa,
545: pay_payroll_actions ppa
546: where ppa.effective_date between p_quarter_start_date
547: and p_quarter_end_date

Line 565: from per_all_assignments_f paaf,

561: CURSOR get_emp_state_codes (p_person_id per_all_people_f.person_id%TYPE,
562: p_year_start_date DATE,
563: p_quarter_end_date DATE) IS
564: select distinct pest.state_code,pus.state_abbrev
565: from per_all_assignments_f paaf,
566: hr_soft_coding_keyflex hsck,
567: pay_us_emp_state_tax_rules_f pest,
568: pay_us_states pus
569: where paaf.person_id = p_person_id

Line 584: from per_all_assignments_f paaf,

580: CURSOR get_missed_emp_state_codes (p_person_id per_all_people_f.person_id%TYPE,
581: p_year_start_date DATE,
582: p_quarter_end_date DATE) IS
583: select distinct substr(peev.screen_entry_value,1,2),pus.state_abbrev
584: from per_all_assignments_f paaf,
585: hr_soft_coding_keyflex hsck,
586: pay_element_entries_f pee,
587: pay_element_entry_values_f peev,
588: pay_input_values_f piv1,

Line 623: from per_all_assignments_f paaf,

619:
620: minus
621:
622: select distinct pest.state_code,pus.state_abbrev
623: from per_all_assignments_f paaf,
624: hr_soft_coding_keyflex hsck,
625: pay_us_emp_state_tax_rules_f pest,
626: pay_us_states pus
627: where paaf.person_id = p_person_id

Line 697: FROM per_all_assignments_f

693: date for the assignment from payroll actions and use it in balance calls.*/
694:
695: SELECT least(max(effective_end_date),p_reporting_date)
696: INTO l_effective_end_date
697: FROM per_all_assignments_f
698: WHERE assignment_id = p_assignment_id
699: AND assignment_type = 'E'
700: AND effective_end_date >= l_quarter_start_date ;
701: