DBA Data[Home] [Help]

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 2117: pn_payment_terms_all pt,

2113:
2114: CURSOR get_grp_rule_item IS
2115: SELECT pi.grouping_rule_id
2116: FROM pn_payment_items pi,
2117: pn_payment_terms_all pt,
2118: pn_leases_all le
2119: WHERE pi.payment_term_id = pt.payment_term_id
2120: AND pt.lease_id = le.lease_id
2121: AND nvl(pi.export_to_ap_flag,'N') = 'Y'

Line 2133: pn_payment_terms_all pt,

2129:
2130: CURSOR get_grp_rule_term IS
2131: SELECT pt.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 2150: pn_payment_terms_all pt,

2146:
2147: CURSOR get_grp_rule_lease IS
2148: SELECT pld.grouping_rule_id
2149: FROM pn_payment_items pi,
2150: pn_payment_terms_all pt,
2151: pn_leases_all le,
2152: pn_lease_details_all pld
2153: WHERE pi.payment_term_id = pt.payment_term_id
2154: AND pt.lease_id = le.lease_id