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 297: PN_PAYMENT_TERMS_ALL pt, PN_LEASES_ALL le,

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

Line 750: UPDATE pn_payment_terms_all

746: END;
747: END LOOP;
748:
749: FORALL i IN term_ar_tbl.FIRST..term_ar_tbl.LAST
750: UPDATE pn_payment_terms_all
751: SET legal_entity_id = le_ar_tbl(i)
752: WHERE payment_term_id = term_ar_tbl(i);
753:
754: IF dbms_sql.is_open (g_cursor_select_grp) THEN

Line 1924: v_pn_le_id1 PN_PAYMENT_TERMS_ALL.legal_entity_id%TYPE;

1920: l_rule_start_date RA_INTERFACE_LINES.rule_start_date%TYPE := NULL;
1921: l_rows_nogrp INTEGER;
1922: l_count_nogrp INTEGER;
1923: v_pn_payment_term_id1 PN_PAYMENT_ITEMS_ALL.payment_term_id%TYPE;
1924: v_pn_le_id1 PN_PAYMENT_TERMS_ALL.legal_entity_id%TYPE;
1925: v_pn_customer_id1 PN_PAYMENT_ITEMS_ALL.customer_id%TYPE;
1926: v_pn_trx_type_id1 PN_PAYMENT_TERMS.cust_trx_type_id%TYPE;
1927: v_pn_org_id1 PN_PAYMENT_TERMS_ALL.org_id%TYPE;
1928: v_schedule_date PN_PAYMENT_SCHEDULES_ALL.schedule_date%TYPE;

Line 1927: v_pn_org_id1 PN_PAYMENT_TERMS_ALL.org_id%TYPE;

1923: v_pn_payment_term_id1 PN_PAYMENT_ITEMS_ALL.payment_term_id%TYPE;
1924: v_pn_le_id1 PN_PAYMENT_TERMS_ALL.legal_entity_id%TYPE;
1925: v_pn_customer_id1 PN_PAYMENT_ITEMS_ALL.customer_id%TYPE;
1926: v_pn_trx_type_id1 PN_PAYMENT_TERMS.cust_trx_type_id%TYPE;
1927: v_pn_org_id1 PN_PAYMENT_TERMS_ALL.org_id%TYPE;
1928: v_schedule_date PN_PAYMENT_SCHEDULES_ALL.schedule_date%TYPE;
1929:
1930: l_rows_select_nogrp NUMBER;
1931: l_count_select_nogrp NUMBER;

Line 2010: UPDATE pn_payment_terms_all

2006: END;
2007: END LOOP;
2008:
2009: FORALL i IN term_ar_tbl.FIRST..term_ar_tbl.LAST
2010: UPDATE pn_payment_terms_all
2011: SET legal_entity_id = le_ar_tbl(i)
2012: WHERE payment_term_id = term_ar_tbl(i);
2013:
2014: IF dbms_sql.is_open (g_cursor_select_nogrp) THEN