APPS.HR_US_REPORTS dependencies on PER_ALL_ASSIGNMENTS_F

Line 223: l_frequency per_all_assignments_f.frequency%type;

219: l_salary number;
220: l_normal_hours number;
221: l_work_schedule varchar2(150);
222: l_annual_salary number;
223: l_frequency per_all_assignments_f.frequency%type;
224: --
225: Begin
226: --
227: hr_utility.set_location('hr_us_reports.get_salary',5);

Line 915: per_all_assignments_f pas,

911: begin
912: SELECT ppa.display_run_number || '-' || ppe.full_name
913: INTO l_payroll_action_name
914: FROM per_people_f ppe,
915: per_all_assignments_f pas,
916: pay_assignment_actions paa,
917: pay_payroll_actions ppa
918: WHERE ppe.person_id = pas.person_id
919: AND pas.assignment_id = paa.assignment_id

Line 1681: -- change to per_all_assignments_f (speedier)

1677: and eloc.region_2 = P_STATE);
1678: --
1679: -- 2. Count employees within the establishment
1680: --
1681: -- change to per_all_assignments_f (speedier)
1682: cursor c_tot_emps is
1683: select count('ass')
1684: from
1685: per_all_assignments_f ass,

Line 1685: per_all_assignments_f ass,

1681: -- change to per_all_assignments_f (speedier)
1682: cursor c_tot_emps is
1683: select count('ass')
1684: from
1685: per_all_assignments_f ass,
1686: per_gen_hierarchy_nodes pgn
1687: where
1688: ass.business_group_id = P_BUSINESS_GROUP_ID
1689: and ass.assignment_type = 'E'

Line 1699: from per_all_assignments_f paf2

1695: and ass.effective_start_date <= P_DATE_END
1696: and ass.effective_end_date >= P_DATE_START
1697: */
1698: and ass.effective_start_date = (select max(paf2.effective_start_date)
1699: from per_all_assignments_f paf2
1700: where paf2.person_id = ass.person_id
1701: and paf2.primary_flag = 'Y'
1702: and paf2.assignment_type = 'E'
1703: and paf2.effective_start_date