DBA Data[Home] [Help]

APPS.PAY_KR_YEA_PDF_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 288: per_all_assignments_f pa,

284: null exclude,
285: fl.file_id,
286: fl.file_data pdf_file
287: from per_kr_assignment_yea_info pkayi,
288: per_all_assignments_f pa,
289: per_periods_of_service ppos,
290: per_people_f pp,
291: fnd_lobs fl
292: where pkayi.assignment_yea_info_id = nvl(p_assignment_yea_info_id,pkayi.assignment_yea_info_id)

Line 3764: from per_all_assignments_f pa,

3760: --
3761: cursor csr_pcr_dpnt
3762: is
3763: select pcr.contact_relationship_id
3764: from per_all_assignments_f pa,
3765: per_contact_relationships pcr,
3766: per_all_people_f pp_con
3767: where pa.assignment_id = p_assignment_id
3768: and p_effective_date