APPS.PN_REC_CALC_PKG dependencies on DUAL

Line 944: FROM DUAL

940: AND p_as_of_date between lines.start_date AND end_date ;
941:
942: CURSOR csr_check_line_status IS
943: SELECT 'Y'
944: FROM DUAL
945: WHERE exists (SELECT NULL
946: FROM pn_rec_period_lines_all plines
947: ,pn_rec_agr_lines_all lines
948: ,pn_rec_calc_periods_all calc_periods

Line 963: FROM DUAL

959: );
960:
961: CURSOR csr_check_period_line IS
962: SELECT 'Y'
963: FROM DUAL
964: WHERE not exists (SELECT NULL
965: FROM pn_rec_period_lines_all plines
966: ,pn_rec_agr_lines_all lines
967: ,pn_rec_calc_periods_all calc_periods

Line 2738: FROM dual

2734: -- Fix for bug # 3123283
2735:
2736: cursor chk_contr_calculated (p_line_purpose VARCHAR2, p_line_type VARCHAR2) is --Fix for bug # 3123283
2737: SELECT 'Y'
2738: FROM dual
2739: WHERE exists(
2740: SELECT 'Y'
2741: FROM pn_rec_period_lines_all period_lines
2742: ,pn_rec_agreements_all recagr

Line 3566: from dual;

3562: -------------------------------------------------------
3563: IF ( X_REC_PERIOD_LINES_ID IS NULL) THEN
3564: select pn_rec_period_lines_s.nextval
3565: into X_REC_PERIOD_LINES_ID
3566: from dual;
3567: END IF;
3568:
3569: FOR org_rec IN org_cur LOOP
3570: l_org_ID := org_rec.org_id;

Line 3888: FROM dual;

3884: -------------------------------------------------------
3885: IF ( X_PERIOD_BILLREC_ID IS NULL) THEN
3886: SELECT PN_REC_PERIOD_BILL_S.nextval
3887: INTO X_PERIOD_BILLREC_ID
3888: FROM dual;
3889: END IF;
3890:
3891: FOR org_rec IN org_cur LOOP
3892: l_org_ID := org_rec.org_id;

Line 4685: FROM dual

4681:
4682: -- Fix for bug # 3142328
4683: CURSOR get_distributions_exist_nocons IS
4684: SELECT 'Y'
4685: FROM dual
4686: WHERE EXISTS (SELECT 1
4687: FROM pn_distributions_all dist
4688: ,pn_payment_terms_all term
4689: WHERE term.payment_term_id = dist.payment_term_id

Line 4697: FROM dual

4693: ;
4694:
4695: CURSOR get_distributions_exist_cons IS
4696: SELECT 'Y'
4697: FROM dual
4698: WHERE EXISTS (SELECT 1
4699: FROM pn_distributions_all dist
4700: ,pn_payment_terms_all term
4701: WHERE term.payment_term_id = dist.payment_term_id

Line 5401: from dual;

5397: IF l_period_count = 0
5398: THEN
5399: select pn_rec_calc_periods_s.nextval
5400: into l_rec_calc_period_id
5401: from dual;
5402:
5403: insert into pn_rec_calc_periods_all
5404: (rec_calc_period_id,
5405: REC_AGREEMENT_ID,