APPS.PER_QH_SUMMARY_QUERY dependencies on PER_QH_MAINTAIN_QUERY

Line 13: l_main_rec per_qh_maintain_query.mainrec;

9: ,p_template_name IN varchar2
10: ,p_block_name IN varchar2
11: ,p_legislation_code IN varchar2
12: ) is
13: l_main_rec per_qh_maintain_query.mainrec;
14: l_out_rec sumrec;
15: --
16: cursor csr_establishment
17: (p_person_id number) is

Line 29: per_qh_maintain_query.onerow(l_main_rec

25: and pea.establishment_id=pe.establishment_id(+)
26: order by attended_end_date desc, attended_start_date desc;
27: --
28: begin
29: per_qh_maintain_query.onerow(l_main_rec
30: ,p_person_id
31: ,p_assignment_id
32: ,p_effective_date
33: ,p_template_name