DBA Data[Home] [Help]

APPS.PN_EXP_TO_AP dependencies on PN_PAYMENT_SCHEDULES_ALL

Line 72: pn_payment_schedules_all ps,

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,
76: fnd_lookups type_lookup,

Line 1587: UPDATE pn_payment_schedules_all

1583: <> l_prior_payment_schedule_id) THEN
1584:
1585: l_prior_payment_schedule_id := exp_ap_cache(item).pn_payment_schedule_id;
1586:
1587: UPDATE pn_payment_schedules_all
1588: SET transferred_by_user_id = l_last_updated_by,
1589: transfer_date = l_last_update_date,
1590: last_updated_by = l_last_updated_by,
1591: last_update_login = l_last_update_login,

Line 2049: UPDATE pn_payment_schedules_all

2045: <> l_prior_payment_schedule_id ) THEN
2046:
2047: l_prior_payment_schedule_id := exp_ap_cache(item).pn_payment_schedule_id;
2048:
2049: UPDATE pn_payment_schedules_all
2050: SET transferred_by_user_id = l_last_updated_by,
2051: transfer_date = l_last_update_date,
2052: last_updated_by = l_last_updated_by,
2053: last_update_login = l_last_update_login,