APPS.PN_EXP_TO_AP dependencies on PN_PAYMENT_ITEMS

Line 71: FROM pn_payment_items pi,

67: as conv_rate_type,
68: pi.grouping_rule_id as item_grouping_rule_id,
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,

Line 1261: ,'PN-'||PN_PAYMENT_ITEMS_NUM_S.nextval)

1257: ,exchange_date)
1258: VALUES
1259: (AP_INVOICES_INTERFACE_S.nextval
1260: ,NVL(l_invoice_num
1261: ,'PN-'||PN_PAYMENT_ITEMS_NUM_S.nextval)
1262: ,ROUND(l_header_amount,l_precision)
1263: ,exp_ap_cache(l_start).pn_export_currency_code
1264: ,'Lease Number: ' || exp_ap_cache(l_start).pn_lease_num
1265: ,'Oracle Property Manager'

Line 1556: UPDATE pn_payment_items_all

1552: ---------------------------------------------------------------
1553: -- Set Transferred Flag to 'Y' for all payment items exported
1554: -- to AP
1555: ---------------------------------------------------------------
1556: UPDATE pn_payment_items_all
1557: SET transferred_to_ap_flag = 'Y' ,
1558: ap_invoice_num = l_invoice_num,
1559: last_updated_by = l_last_updated_by,
1560: last_update_login = l_last_update_login,

Line 1809: ,'PN-'||PN_PAYMENT_ITEMS_NUM_S.nextval

1805: ,exchange_rate_type
1806: ,exchange_date)
1807: VALUES
1808: (AP_INVOICES_INTERFACE_S.nextval
1809: ,'PN-'||PN_PAYMENT_ITEMS_NUM_S.nextval
1810: ,ROUND(exp_ap_cache(item).pn_export_currency_amount,l_precision)
1811: ,exp_ap_cache(item).pn_export_currency_code
1812: ,'Lease Number: ' || exp_ap_cache(item).pn_lease_num
1813: ,'Oracle Property Manager'

Line 2011: UPDATE pn_payment_items_all

2007: ---------------------------------------------------------------
2008: -- Set Transferred Flag to 'Y' for all payment items exported
2009: -- to AP
2010: ---------------------------------------------------------------
2011: UPDATE pn_payment_items_all
2012: SET transferred_to_ap_flag = 'Y' ,
2013: ap_invoice_num = l_invoice_num,
2014: last_updated_by = l_last_updated_by,
2015: last_update_login = l_last_update_login,

Line 2116: FROM pn_payment_items pi,

2112: IS
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

Line 2132: FROM pn_payment_items pi,

2128: GROUP BY pi.grouping_rule_id;
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

Line 2149: FROM pn_payment_items pi,

2145: GROUP BY pt.grouping_rule_id;
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