APPS.PN_INDEX_LEASE_COMMON_PKG dependencies on DUAL

Line 80: FROM DUAL

76: IF p_index_lease_period_id IS NULL
77: THEN
78: SELECT '1'
79: INTO v
80: FROM DUAL
81: WHERE EXISTS (
82: SELECT 1
83: FROM pn_index_lease_periods_all pilp
84: ,pn_payment_terms_all ppt

Line 98: FROM DUAL

94: OR NVL (p_chk_index_ind, 'N') = 'N'));
95: ELSE
96: SELECT '1'
97: INTO v
98: FROM DUAL
99: WHERE EXISTS (
100: SELECT 1
101: FROM pn_payment_terms_all ppt
102: WHERE ppt.index_period_id = p_index_lease_period_id

Line 151: FROM DUAL

147:
148: BEGIN
149: SELECT '1'
150: INTO v
151: FROM DUAL
152: WHERE EXISTS ( SELECT 1
153: FROM pn_payment_items_all ppi, pn_payment_terms_all ppt
154: WHERE ppt.payment_term_id = ppi.payment_term_id
155: AND ppi.payment_item_type_lookup_code = 'CASH'

Line 700: FROM DUAL

696: l_period_exists NUMBER;
697: BEGIN
698: SELECT 1
699: INTO l_period_exists
700: FROM DUAL
701: WHERE EXISTS ( SELECT periods.index_period_id
702: FROM pn_index_lease_periods_all periods
703: WHERE periods.index_lease_id = p_index_lease_id);
704: RETURN l_period_exists;

Line 727: FROM DUAL

723: l_term_exists NUMBER;
724: BEGIN
725: SELECT 1
726: INTO l_term_exists
727: FROM DUAL
728: WHERE EXISTS ( SELECT ppt.payment_term_id
729: FROM pn_payment_terms_all ppt
730: WHERE ppt.index_period_id = p_index_period_id);
731: RETURN l_term_exists;

Line 754: FROM DUAL

750: l_term_exists NUMBER;
751: BEGIN
752: SELECT 1
753: INTO l_term_exists
754: FROM DUAL
755: WHERE EXISTS ( SELECT ppt.payment_term_id
756: FROM pn_payment_terms_all ppt
757: WHERE ppt.index_period_id = p_index_period_id
758: AND ppt.status = 'APPROVED');

Line 783: FROM DUAL

779: l_template_used NUMBER;
780: BEGIN
781: SELECT 1
782: INTO l_template_used
783: FROM DUAL
784: WHERE EXISTS ( SELECT pil.index_lease_id
785: FROM pn_index_leases_all pil, pn_term_templates_all ptt
786: WHERE ptt.term_template_id = pil.term_template_id
787: AND ptt.term_template_id = p_term_template_id);

Line 1182: FROM DUAL

1178: BEGIN
1179: BEGIN
1180: SELECT 1
1181: INTO l_hist_line_used
1182: FROM DUAL
1183: WHERE EXISTS ( SELECT periods.previous_index_line_id
1184: FROM pn_index_lease_periods_all periods
1185: ,pn_index_history_lines lines
1186: WHERE periods.previous_index_line_id = lines.index_line_id

Line 1200: FROM DUAL

1196: THEN
1197: BEGIN
1198: SELECT 2
1199: INTO l_hist_line_used
1200: FROM DUAL
1201: WHERE EXISTS ( SELECT periods.current_index_line_id
1202: FROM pn_index_lease_periods_all periods
1203: ,pn_index_history_lines lines
1204: WHERE periods.current_index_line_id = lines.index_line_id

Line 1232: FROM DUAL

1228: l_calc_exists NUMBER;
1229: BEGIN
1230: SELECT 1
1231: INTO l_calc_exists
1232: FROM DUAL
1233: WHERE EXISTS ( SELECT terms.payment_term_id
1234: FROM pn_payment_terms_all terms
1235: ,pn_index_leases_all lease
1236: ,pn_index_lease_periods_all periods

Line 1263: FROM DUAL

1259: l_basis_exists NUMBER;
1260: BEGIN
1261: SELECT 1
1262: INTO l_basis_exists
1263: FROM DUAL
1264: WHERE EXISTS ( SELECT current_basis
1265: FROM pn_index_lease_periods_all
1266: WHERE index_lease_id = p_index_lease_id
1267: AND current_basis is null);