[Home] [Help]
55: )
56: IS
57: SELECT itp.item_property_id
58: FROM hr_item_properties_b itp
59: ,hr_template_items_b ti2
60: ,hr_form_items_b fi2
61: ,hr_form_items_b fi1
62: ,hr_template_items_b ti1
63: WHERE itp.template_item_id = ti2.template_item_id
58: FROM hr_item_properties_b itp
59: ,hr_template_items_b ti2
60: ,hr_form_items_b fi2
61: ,hr_form_items_b fi1
62: ,hr_template_items_b ti1
63: WHERE itp.template_item_id = ti2.template_item_id
64: AND ti2.form_template_id = ti1.form_template_id
65: AND ti2.form_item_id = fi2.form_item_id
66: AND fi2.application_id = fi1.application_id
76: IS
77: SELECT itp.item_property_id
78: FROM hr_item_properties_b itp
79: ,hr_template_item_contexts_b tc2
80: ,hr_template_items_b ti2
81: ,hr_form_items_b fi2
82: ,hr_form_items_b fi1
83: ,hr_template_items_b ti1
84: ,hr_template_item_contexts_b tc1
79: ,hr_template_item_contexts_b tc2
80: ,hr_template_items_b ti2
81: ,hr_form_items_b fi2
82: ,hr_form_items_b fi1
83: ,hr_template_items_b ti1
84: ,hr_template_item_contexts_b tc1
85: WHERE itp.template_item_context_id = tc2.template_item_context_id
86: AND tc2.item_context_id = tc1.item_context_id
87: AND tc2.template_item_id = ti2.template_item_id
1089:
1090: CURSOR cur_check
1091: IS
1092: SELECT 1
1093: FROM hr_template_items tit
1094: WHERE tit.template_item_id = p_template_item_id
1095: AND tit.form_item_id = p_form_item_id;
1096:
1097: -- added a outer join so that the correct values are returned
1665: ,DECODE(p_information30,hr_api.g_varchar2,itp.information30,p_information30)
1666: ,DECODE(p_next_navigation_item_id,hr_api.g_number,itp.next_navigation_item_id,p_next_navigation_item_id)
1667: ,DECODE(p_previous_navigation_item_id,hr_api.g_number,itp.previous_navigation_item_id,p_previous_navigation_item_id)
1668: FROM hr_item_properties_b itp
1669: , hr_template_items_b hti
1670: WHERE itp.template_item_id (+) = hti.template_item_id
1671: AND hti.template_item_id = p_template_item_id;
1672:
1673: CURSOR cur_item_tl
2093:
2094: CURSOR cur_check
2095: IS
2096: SELECT tit.form_item_id
2097: FROM hr_template_items tit
2098: WHERE tit.template_item_id = p_template_item_id_from
2099: INTERSECT
2100: SELECT tit.form_item_id
2101: FROM hr_template_items tit
2097: FROM hr_template_items tit
2098: WHERE tit.template_item_id = p_template_item_id_from
2099: INTERSECT
2100: SELECT tit.form_item_id
2101: FROM hr_template_items tit
2102: WHERE tit.template_item_id = p_template_item_id_to;
2103:
2104: CURSOR cur_item_prop
2105: IS
2168: ,DECODE(p_information30,hr_api.g_varchar2,itp.information30,p_information30)
2169: ,DECODE(p_next_navigation_item_id,hr_api.g_number,itp.next_navigation_item_id,p_next_navigation_item_id)
2170: ,DECODE(p_previous_navigation_item_id,hr_api.g_number,itp.previous_navigation_item_id,p_previous_navigation_item_id)
2171: FROM hr_item_properties_b itp
2172: ,hr_template_items_b hti
2173: WHERE itp.template_item_id (+) = hti.template_item_id
2174: AND hti.template_item_id = p_template_item_id_from;
2175:
2176: CURSOR cur_item_tl
2598: CURSOR cur_check
2599: IS
2600: SELECT tiw.form_item_id
2601: FROM hr_template_item_contexts tic
2602: , hr_template_items_b tiw
2603: WHERE tic.template_item_id = tiw.template_item_id
2604: AND tic.template_item_context_id = p_template_item_context_id_frm
2605: INTERSECT
2606: SELECT tiw.form_item_id
2604: AND tic.template_item_context_id = p_template_item_context_id_frm
2605: INTERSECT
2606: SELECT tiw.form_item_id
2607: FROM hr_template_item_contexts tic
2608: , hr_template_items_b tiw
2609: WHERE tic.template_item_id = tiw.template_item_id
2610: AND tic.template_item_context_id = p_template_item_context_id_to;
2611:
2612: CURSOR cur_item_prop