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 1263: ,'PN-'||PN_PAYMENT_ITEMS_NUM_S.nextval)

1259: ,ADD_TAX_TO_INV_AMT_FLAG)--For Bug 9068811
1260: VALUES
1261: (AP_INVOICES_INTERFACE_S.nextval
1262: ,NVL(l_invoice_num
1263: ,'PN-'||PN_PAYMENT_ITEMS_NUM_S.nextval)
1264: ,ROUND(l_header_amount,l_precision)
1265: ,exp_ap_cache(l_start).pn_export_currency_code
1266: ,'Lease Number: ' || exp_ap_cache(l_start).pn_lease_num
1267: ,'Oracle Property Manager'

Line 1564: UPDATE pn_payment_items_all

1560: ---------------------------------------------------------------
1561: -- Set Transferred Flag to 'Y' for all payment items exported
1562: -- to AP
1563: ---------------------------------------------------------------
1564: UPDATE pn_payment_items_all
1565: SET transferred_to_ap_flag = 'Y' ,
1566: ap_invoice_num = l_invoice_num,
1567: last_updated_by = l_last_updated_by,
1568: last_update_login = l_last_update_login,

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

1815: ,CALC_TAX_DURING_IMPORT_FLAG
1816: ,ADD_TAX_TO_INV_AMT_FLAG)--For Bug 9068811
1817: VALUES
1818: (AP_INVOICES_INTERFACE_S.nextval
1819: ,'PN-'||PN_PAYMENT_ITEMS_NUM_S.nextval
1820: ,ROUND(exp_ap_cache(item).pn_export_currency_amount,l_precision)
1821: ,exp_ap_cache(item).pn_export_currency_code
1822: ,'Lease Number: ' || exp_ap_cache(item).pn_lease_num
1823: ,'Oracle Property Manager'

Line 2027: UPDATE pn_payment_items_all

2023: ---------------------------------------------------------------
2024: -- Set Transferred Flag to 'Y' for all payment items exported
2025: -- to AP
2026: ---------------------------------------------------------------
2027: UPDATE pn_payment_items_all
2028: SET transferred_to_ap_flag = 'Y' ,
2029: ap_invoice_num = l_invoice_num,
2030: last_updated_by = l_last_updated_by,
2031: last_update_login = l_last_update_login,

Line 2132: FROM pn_payment_items pi,

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

Line 2148: FROM pn_payment_items pi,

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

Line 2165: FROM pn_payment_items pi,

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