APPS.PAY_US_SQWL_UDF dependencies on PER_ALL_PEOPLE_F

Line 561: CURSOR get_emp_state_codes (p_person_id per_all_people_f.person_id%TYPE,

557: and asg.assignment_id = p_assignment_id;
558:
559: /*End Bug#9561700*/
560:
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,

Line 580: CURSOR get_missed_emp_state_codes (p_person_id per_all_people_f.person_id%TYPE,

576: and pest.effective_end_date >= p_year_start_date
577: and pest.effective_start_date <= p_quarter_end_date
578: and pus.state_code=pest.state_code;
579:
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,

Line 650: l_person_id per_all_people_f.person_id%TYPE;

646: and pbd.dimension_name = p_dimension_name
647: and pdb.balance_type_id = pbt.balance_type_id
648: and pdb.balance_dimension_id = pbd.balance_dimension_id;
649:
650: l_person_id per_all_people_f.person_id%TYPE;
651: l_state_code pay_us_states.state_code%TYPE;
652: l_state_abbrev pay_us_states.state_abbrev%TYPE;
653: l_out_of_state_code pay_us_states.state_abbrev%TYPE;
654: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;