APPS.PN_EXP_TO_AR dependencies on PN_PAYMENT_TERMS_ALL

Line 244: PN_PAYMENT_TERMS_ALL pt, PN_LEASES_ALL le,

240: , ''MM/DD/YYYY''))
241: ,''MM/DD/YYYY'') as rule_gl_date,
242: ps.schedule_date as schedule_date
243: FROM PN_PAYMENT_ITEMS pi, PN_PAYMENT_SCHEDULES_ALL ps,
244: PN_PAYMENT_TERMS_ALL pt, PN_LEASES_ALL le,
245: PN_LEASE_DETAILS_ALL pld, HZ_CUST_SITE_USES_ALL hzc,
246: HZ_CUST_SITE_USES_ALL hzc1, HZ_PARTIES party,
247: HZ_CUST_ACCOUNTS_ALL cust_acc, FND_LOOKUPS type_lookup,
248: FND_LOOKUPS purpose_lookup, HR_OPERATING_UNITS ou,

Line 298: PN_PAYMENT_TERMS_ALL pt, PN_LEASES_ALL le,

294: pt.payment_purpose_code as payment_purpose,
295: pt.payment_term_type_code as payment_type,
296: ps.schedule_date as schedule_date
297: FROM PN_PAYMENT_ITEMS pi, PN_PAYMENT_SCHEDULES_ALL ps,
298: PN_PAYMENT_TERMS_ALL pt, PN_LEASES_ALL le,
299: HZ_CUST_SITE_USES_ALL hzc, HZ_CUST_SITE_USES_ALL hzc1,
300: hz_parties party, hz_cust_accounts_ALL cust_acc,
301: fnd_lookups type_lookup, fnd_lookups purpose_lookup,
302: hr_operating_units ou

Line 759: UPDATE pn_payment_terms_all

755: END;
756: END LOOP;
757:
758: FORALL i IN term_ar_tbl.FIRST..term_ar_tbl.LAST
759: UPDATE pn_payment_terms_all
760: SET legal_entity_id = le_ar_tbl(i)
761: WHERE payment_term_id = term_ar_tbl(i);
762:
763: IF dbms_sql.is_open (g_cursor_select_grp) THEN

Line 1970: v_pn_le_id1 PN_PAYMENT_TERMS_ALL.legal_entity_id%TYPE;

1966: l_rule_start_date RA_INTERFACE_LINES.rule_start_date%TYPE := NULL;
1967: l_rows_nogrp INTEGER;
1968: l_count_nogrp INTEGER;
1969: v_pn_payment_term_id1 PN_PAYMENT_ITEMS_ALL.payment_term_id%TYPE;
1970: v_pn_le_id1 PN_PAYMENT_TERMS_ALL.legal_entity_id%TYPE;
1971: v_pn_customer_id1 PN_PAYMENT_ITEMS_ALL.customer_id%TYPE;
1972: v_pn_trx_type_id1 PN_PAYMENT_TERMS.cust_trx_type_id%TYPE;
1973: v_pn_org_id1 PN_PAYMENT_TERMS_ALL.org_id%TYPE;
1974: v_schedule_date PN_PAYMENT_SCHEDULES_ALL.schedule_date%TYPE;

Line 1973: v_pn_org_id1 PN_PAYMENT_TERMS_ALL.org_id%TYPE;

1969: v_pn_payment_term_id1 PN_PAYMENT_ITEMS_ALL.payment_term_id%TYPE;
1970: v_pn_le_id1 PN_PAYMENT_TERMS_ALL.legal_entity_id%TYPE;
1971: v_pn_customer_id1 PN_PAYMENT_ITEMS_ALL.customer_id%TYPE;
1972: v_pn_trx_type_id1 PN_PAYMENT_TERMS.cust_trx_type_id%TYPE;
1973: v_pn_org_id1 PN_PAYMENT_TERMS_ALL.org_id%TYPE;
1974: v_schedule_date PN_PAYMENT_SCHEDULES_ALL.schedule_date%TYPE;
1975:
1976: l_rows_select_nogrp NUMBER;
1977: l_count_select_nogrp NUMBER;

Line 2061: UPDATE pn_payment_terms_all

2057: END;
2058: END LOOP;
2059:
2060: FORALL i IN term_ar_tbl.FIRST..term_ar_tbl.LAST
2061: UPDATE pn_payment_terms_all
2062: SET legal_entity_id = le_ar_tbl(i)
2063: WHERE payment_term_id = term_ar_tbl(i);
2064:
2065: IF dbms_sql.is_open (g_cursor_select_nogrp) THEN