APPS.PN_EXP_TO_AP dependencies on PN_PAYMENT_TERMS_ALL

Line 73: pn_payment_terms_all pt,

69: pt.grouping_rule_id as term_grouping_rule_id,
70: pld.grouping_rule_id as lease_grouping_rule_id
71: FROM pn_payment_items pi,
72: pn_payment_schedules_all ps,
73: pn_payment_terms_all pt,
74: pn_leases_all le,
75: pn_lease_details_all pld,
76: fnd_lookups type_lookup,
77: fnd_lookups purpose_lookup,

Line 795: UPDATE pn_payment_terms_all

791: dbms_sql.close_cursor (l_cursor_2);
792: END IF;
793:
794: FORALL i IN term_ID_tbl.FIRST..term_ID_tbl.LAST
795: UPDATE pn_payment_terms_all
796: SET legal_entity_id = LE_tbl(i)
797: WHERE payment_term_id = term_ID_tbl(i);
798:
799: l_rows := dbms_sql.execute(l_cursor);

Line 2133: pn_payment_terms_all pt,

2129:
2130: CURSOR get_grp_rule_item IS
2131: SELECT pi.grouping_rule_id
2132: FROM pn_payment_items pi,
2133: pn_payment_terms_all pt,
2134: pn_leases_all le
2135: WHERE pi.payment_term_id = pt.payment_term_id
2136: AND pt.lease_id = le.lease_id
2137: AND nvl(pi.export_to_ap_flag,'N') = 'Y'

Line 2149: pn_payment_terms_all pt,

2145:
2146: CURSOR get_grp_rule_term IS
2147: SELECT pt.grouping_rule_id
2148: FROM pn_payment_items pi,
2149: pn_payment_terms_all pt,
2150: pn_leases_all le
2151: WHERE pi.payment_term_id = pt.payment_term_id
2152: AND pt.lease_id = le.lease_id
2153: AND nvl(pi.export_to_ap_flag,'N') = 'Y'

Line 2166: pn_payment_terms_all pt,

2162:
2163: CURSOR get_grp_rule_lease IS
2164: SELECT pld.grouping_rule_id
2165: FROM pn_payment_items pi,
2166: pn_payment_terms_all pt,
2167: pn_leases_all le,
2168: pn_lease_details_all pld
2169: WHERE pi.payment_term_id = pt.payment_term_id
2170: AND pt.lease_id = le.lease_id