APPS.PN_NORM_RENORM_PKG dependencies on PN_PAYMENT_TERMS_ALL

Line 118: FROM pn_payment_terms_all

114:
115:
116: CURSOR org_cur IS
117: SELECT org_id
118: FROM pn_payment_terms_all
119: WHERE payment_term_id = p_term_id;
120:
121: /*Bug4956314 */
122: CURSOR check_cash_item (b_schedule_id NUMBER,b_term_id NUMBER)

Line 519: UPDATE pn_payment_terms_all

515:
516: END LOOP;
517:
518: /* update the table */
519: UPDATE pn_payment_terms_all
520: SET event_type_code = p_lease_context,
521: norm_start_date = p_norm_str_dt,
522: norm_end_date = p_norm_end_dt
523: WHERE normalize ='Y'

Line 644: FROM pn_payment_terms_all

640: l_end_fraction_amt NUMBER;
641:
642: CURSOR org_cur IS
643: SELECT org_id
644: FROM pn_payment_terms_all
645: WHERE payment_term_id = p_term_id;
646:
647: /*Bug4956314 */
648: CURSOR check_cash_item (b_schedule_id NUMBER,b_term_id NUMBER)

Line 976: UPDATE pn_payment_terms_all

972:
973: END LOOP;
974:
975: /* update the table */
976: UPDATE pn_payment_terms_all
977: SET event_type_code = p_lease_context,
978: norm_start_date = p_norm_str_dt,
979: norm_end_date = p_norm_end_dt
980: WHERE normalize ='Y'

Line 1031: CURSOR GET_TERM_SCHEDULES(c_norm_str_dt pn_payment_terms_all.norm_start_date%TYPE) IS

1027:
1028: l_amd_comn_date DATE; /* 6838211 */
1029: /* get the details of draft schedules between norm start and end dates*/
1030: -- Bug#6829173
1031: CURSOR GET_TERM_SCHEDULES(c_norm_str_dt pn_payment_terms_all.norm_start_date%TYPE) IS
1032: SELECT pps.schedule_date schedule_date,
1033: pps.payment_schedule_id payment_schedule_id
1034: FROM pn_payment_schedules_all pps,
1035: pn_payment_items_all ppi

Line 1063: FROM pn_payment_terms_all

1059: l_system_options VARCHAR2(5);
1060:
1061: CURSOR org_cur IS
1062: SELECT org_id
1063: FROM pn_payment_terms_all
1064: WHERE payment_term_id = p_term_id;
1065:
1066: l_org_id NUMBER;
1067:

Line 1070: l_norm_str_dt pn_payment_terms_all.norm_start_date%TYPE;

1066: l_org_id NUMBER;
1067:
1068: -- Bug#6829173
1069: l_lease_comm_date pn_lease_details_all.lease_commencement_date%TYPE;
1070: l_norm_str_dt pn_payment_terms_all.norm_start_date%TYPE;
1071: lp_norm_str_dt pn_payment_terms_all.norm_start_date%TYPE := NULL;
1072:
1073:
1074: BEGIN

Line 1071: lp_norm_str_dt pn_payment_terms_all.norm_start_date%TYPE := NULL;

1067:
1068: -- Bug#6829173
1069: l_lease_comm_date pn_lease_details_all.lease_commencement_date%TYPE;
1070: l_norm_str_dt pn_payment_terms_all.norm_start_date%TYPE;
1071: lp_norm_str_dt pn_payment_terms_all.norm_start_date%TYPE := NULL;
1072:
1073:
1074: BEGIN
1075: pnp_debug_pkg.log('PN_NORM_RENORM_PKG.NORMALIZE_RENORMALIZE (+) ');