APPS.HR_CANVAS_PROPERTIES_PKG dependencies on HR_TEMPLATE_CANVASES_B

Line 58: ,HR_TEMPLATE_CANVASES_B tcn

54: l_original csr_original%rowtype;
55: cursor csr_copies is
56: select cnp.canvas_property_id
57: from HR_CANVAS_PROPERTIES cnp
58: ,HR_TEMPLATE_CANVASES_B tcn
59: ,HR_TEMPLATE_WINDOWS_B twn
60: ,HR_TEMPLATE_CANVASES_B tco
61: where cnp.TEMPLATE_CANVAS_ID = tcn.TEMPLATE_CANVAS_ID
62: and tcn.TEMPLATE_WINDOW_ID = twn.TEMPLATE_WINDOW_ID

Line 60: ,HR_TEMPLATE_CANVASES_B tco

56: select cnp.canvas_property_id
57: from HR_CANVAS_PROPERTIES cnp
58: ,HR_TEMPLATE_CANVASES_B tcn
59: ,HR_TEMPLATE_WINDOWS_B twn
60: ,HR_TEMPLATE_CANVASES_B tco
61: where cnp.TEMPLATE_CANVAS_ID = tcn.TEMPLATE_CANVAS_ID
62: and tcn.TEMPLATE_WINDOW_ID = twn.TEMPLATE_WINDOW_ID
63: and twn.FORM_TEMPLATE_ID in (select sft.FORM_TEMPLATE_ID_TO
64: from HR_SOURCE_FORM_TEMPLATES sft

Line 223: p_ref_entity_info => per_ric_pkg.ref_entity_tbl(per_ric_pkg.Ref_info_rec('HR_TEMPLATE_CANVASES_B',PER_RIC_PKG.column_info_tbl(

219: --
220: BEGIN
221: per_ric_pkg.Chk_integrity (
222: p_entity_name => 'HR_CANVAS_PROPERTIES',
223: p_ref_entity_info => per_ric_pkg.ref_entity_tbl(per_ric_pkg.Ref_info_rec('HR_TEMPLATE_CANVASES_B',PER_RIC_PKG.column_info_tbl(
224: PER_RIC_PKG.Col_info_rec('TEMPLATE_CANVAS_ID', NULL,x_template_canvas_id, NULL))),
225: per_ric_pkg.Ref_info_rec('HR_FORM_CANVASES_B', PER_RIC_PKG.column_info_tbl(
226: PER_RIC_PKG.Col_info_rec('FORM_CANVAS_ID', NULL, x_form_canvas_id, NULL)))),
227: p_ref_type => 'INS');

Line 714: from hr_template_canvases_b htc

710: IF ltrim(rtrim(x_template_name)) is not null then
711:
712: select htc.template_canvas_id
713: into x_template_canvas_id
714: from hr_template_canvases_b htc
715: ,hr_template_windows_b htw
716: , hr_form_templates hft
717: where htc.form_canvas_id = x_form_canvas_id
718: and htc.template_window_id = htw.template_window_id