APPS.HR_WINDOW_PROPERTIES_PKG dependencies on HR_TEMPLATE_WINDOWS_B

Line 58: ,HR_TEMPLATE_WINDOWS_B twn

54: l_original csr_original%rowtype;
55: cursor csr_copies is
56: select wnp.window_property_id
57: from HR_WINDOW_PROPERTIES_B wnp
58: ,HR_TEMPLATE_WINDOWS_B twn
59: ,HR_TEMPLATE_WINDOWS_B two
60: where wnp.TEMPLATE_WINDOW_ID = twn.TEMPLATE_WINDOW_ID
61: and twn.FORM_TEMPLATE_ID in (select sft.FORM_TEMPLATE_ID_TO
62: from HR_SOURCE_FORM_TEMPLATES sft

Line 59: ,HR_TEMPLATE_WINDOWS_B two

55: cursor csr_copies is
56: select wnp.window_property_id
57: from HR_WINDOW_PROPERTIES_B wnp
58: ,HR_TEMPLATE_WINDOWS_B twn
59: ,HR_TEMPLATE_WINDOWS_B two
60: where wnp.TEMPLATE_WINDOW_ID = twn.TEMPLATE_WINDOW_ID
61: and twn.FORM_TEMPLATE_ID in (select sft.FORM_TEMPLATE_ID_TO
62: from HR_SOURCE_FORM_TEMPLATES sft
63: start with sft.FORM_TEMPLATE_ID_FROM = two.FORM_TEMPLATE_ID

Line 218: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_WINDOWS_B', PER_RIC_PKG.column_info_tbl(

214: p_entity_name => 'HR_WINDOW_PROPERTIES_B',
215: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
216: PER_RIC_PKG.ref_info_rec('HR_FORM_WINDOWS_B', PER_RIC_PKG.column_info_tbl(
217: PER_RIC_PKG.col_info_rec('FORM_WINDOW_ID',NULL,X_FORM_WINDOW_ID,NULL))),
218: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_WINDOWS_B', PER_RIC_PKG.column_info_tbl(
219: PER_RIC_PKG.col_info_rec('TEMPLATE_WINDOW_ID',NULL,X_TEMPLATE_WINDOW_ID,NULL)))
220: ),
221: p_ref_type => 'INS');
222:

Line 828: ,hr_template_windows_b hti

824:
825: select hti.template_window_id
826: into x_template_window_id
827: from hr_form_templates_b hft
828: ,hr_template_windows_b hti
829: where hti.form_window_id = x_form_window_id
830: and hti.form_template_id = hft.form_template_id
831: and hft.form_id = x_form_id
832: and hft.application_id = x_application_id

Line 949: ,hr_template_windows_b hti

945:
946: select hti.template_window_id
947: into x_template_window_id
948: from hr_form_templates_b hft
949: ,hr_template_windows_b hti
950: where hti.form_window_id = x_form_window_id
951: and hti.form_template_id = hft.form_template_id
952: and hft.form_id = x_form_id
953: and hft.application_id = x_application_id