APPS.PN_REC_CALC_PKG dependencies on DUAL

Line 919: FROM DUAL

915: AND p_as_of_date between lines.start_date AND end_date ;
916:
917: CURSOR csr_check_line_status IS
918: SELECT 'Y'
919: FROM DUAL
920: WHERE exists (SELECT NULL
921: FROM pn_rec_period_lines_all plines
922: ,pn_rec_agr_lines_all lines
923: ,pn_rec_calc_periods_all calc_periods

Line 938: FROM DUAL

934: );
935:
936: CURSOR csr_check_period_line IS
937: SELECT 'Y'
938: FROM DUAL
939: WHERE not exists (SELECT NULL
940: FROM pn_rec_period_lines_all plines
941: ,pn_rec_agr_lines_all lines
942: ,pn_rec_calc_periods_all calc_periods

Line 2704: FROM dual

2700: -- Fix for bug # 3123283
2701:
2702: cursor chk_contr_calculated (p_line_purpose VARCHAR2, p_line_type VARCHAR2) is --Fix for bug # 3123283
2703: SELECT 'Y'
2704: FROM dual
2705: WHERE exists(
2706: SELECT 'Y'
2707: FROM pn_rec_period_lines_all period_lines
2708: ,pn_rec_agreements_all recagr

Line 3481: from dual;

3477: -------------------------------------------------------
3478: IF ( X_REC_PERIOD_LINES_ID IS NULL) THEN
3479: select pn_rec_period_lines_s.nextval
3480: into X_REC_PERIOD_LINES_ID
3481: from dual;
3482: END IF;
3483:
3484: FOR org_rec IN org_cur LOOP
3485: l_org_ID := org_rec.org_id;

Line 3803: FROM dual;

3799: -------------------------------------------------------
3800: IF ( X_PERIOD_BILLREC_ID IS NULL) THEN
3801: SELECT PN_REC_PERIOD_BILL_S.nextval
3802: INTO X_PERIOD_BILLREC_ID
3803: FROM dual;
3804: END IF;
3805:
3806: FOR org_rec IN org_cur LOOP
3807: l_org_ID := org_rec.org_id;

Line 4600: FROM dual

4596:
4597: -- Fix for bug # 3142328
4598: CURSOR get_distributions_exist_nocons IS
4599: SELECT 'Y'
4600: FROM dual
4601: WHERE EXISTS (SELECT 1
4602: FROM pn_distributions_all dist
4603: ,pn_payment_terms_all term
4604: WHERE term.payment_term_id = dist.payment_term_id

Line 4612: FROM dual

4608: ;
4609:
4610: CURSOR get_distributions_exist_cons IS
4611: SELECT 'Y'
4612: FROM dual
4613: WHERE EXISTS (SELECT 1
4614: FROM pn_distributions_all dist
4615: ,pn_payment_terms_all term
4616: WHERE term.payment_term_id = dist.payment_term_id

Line 5316: from dual;

5312: IF l_period_count = 0
5313: THEN
5314: select pn_rec_calc_periods_s.nextval
5315: into l_rec_calc_period_id
5316: from dual;
5317:
5318: insert into pn_rec_calc_periods_all
5319: (rec_calc_period_id,
5320: REC_AGREEMENT_ID,