APPS.PN_EXP_TO_AR dependencies on PN_PAYMENT_SCHEDULES

Line 243: FROM PN_PAYMENT_ITEMS pi, PN_PAYMENT_SCHEDULES_ALL ps,

239: pn_mo_cache_utils.get_current_org_id)
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,

Line 296: FROM PN_PAYMENT_ITEMS pi, PN_PAYMENT_SCHEDULES_ALL ps,

292: PT.Location_id,
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,

Line 655: v_pn_period_name PN_PAYMENT_SCHEDULES.period_name%TYPE;

651: v_pn_proj_attr7 PN_PAYMENT_TERMS.project_attribute7%TYPE;
652: v_pn_org_id PN_PAYMENT_TERMS.org_id%TYPE;
653: v_pn_lease_num PN_LEASES.lease_num%TYPE;
654: v_pn_payment_schedule_id PN_PAYMENT_ITEMS.payment_schedule_id%TYPE;
655: v_pn_period_name PN_PAYMENT_SCHEDULES.period_name%TYPE;
656: v_pn_description PN_PAYMENT_TERMS.payment_purpose_code%TYPE;
657: v_pn_lease_id PN_LEASES.lease_id%TYPE;
658: v_transaction_date PN_PAYMENT_ITEMS.due_date%TYPE;
659: v_normalize PN_PAYMENT_TERMS.normalize%TYPE;

Line 671: v_schedule_date PN_PAYMENT_SCHEDULES.schedule_date%TYPE;

667: v_conv_rate PN_PAYMENT_ITEMS.rate%TYPE;
668: v_payment_purpose PN_PAYMENT_TERMS.payment_purpose_code%TYPE;
669: v_payment_type PN_PAYMENT_TERMS.payment_term_type_code%TYPE;
670: v_rule_gl_date RA_CUST_TRX_LINE_GL_DIST.gl_date%TYPE;
671: v_schedule_date PN_PAYMENT_SCHEDULES.schedule_date%TYPE;
672: v_pn_payment_term_id1 PN_PAYMENT_ITEMS.payment_term_id%TYPE;
673: v_pn_le_id1 PN_PAYMENT_TERMS.legal_entity_id%TYPE;
674: v_pn_customer_id1 PN_PAYMENT_ITEMS.customer_id%TYPE;
675: v_pn_trx_type_id1 PN_PAYMENT_TERMS.cust_trx_type_id%TYPE;

Line 1711: UPDATE PN_PAYMENT_SCHEDULES_ALL

1707: pnp_debug_pkg.log('Updating payment schedules for payment sch id : ' ||
1708: to_char(exp_ar_tbl(l_grp).PN_Payment_Schedule_Id) );
1709:
1710:
1711: UPDATE PN_PAYMENT_SCHEDULES_ALL
1712: SET Transferred_By_User_Id = l_last_updated_by,
1713: Transfer_Date = l_last_update_date
1714: WHERE Payment_Schedule_Id = exp_ar_tbl(l_grp).PN_Payment_Schedule_Id;
1715:

Line 1827: v_pn_period_name PN_PAYMENT_SCHEDULES.period_name%TYPE;

1823: )
1824: IS
1825: v_pn_lease_num PN_LEASES.lease_num%TYPE;
1826: v_pn_lease_id PN_LEASES.lease_id%TYPE;
1827: v_pn_period_name PN_PAYMENT_SCHEDULES.period_name%TYPE;
1828: v_pn_code_combination_id PN_PAYMENT_TERMS.code_combination_id%TYPE;
1829: v_pn_cust_ship_site_id PN_PAYMENT_TERMS.cust_ship_site_id%TYPE;
1830: v_pn_tax_code_id PN_PAYMENT_TERMS.tax_code_id%TYPE;
1831: v_pn_tcc PN_PAYMENT_TERMS.tax_classification_code%TYPE;

Line 1928: v_schedule_date PN_PAYMENT_SCHEDULES_ALL.schedule_date%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;
1932: TYPE le_ar_tbl_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;

Line 2777: UPDATE PN_PAYMENT_SCHEDULES_ALL

2773:
2774: pnp_debug_pkg.log('Updating payment schedules for payment sch id : ' ||
2775: to_char(V_PN_Payment_Schedule_Id) );
2776:
2777: UPDATE PN_PAYMENT_SCHEDULES_ALL
2778: SET Transferred_By_User_Id = l_last_updated_by,
2779: Transfer_Date = l_last_update_date
2780: WHERE Payment_Schedule_Id = V_PN_Payment_Schedule_Id;
2781: