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 1579: UPDATE pn_payment_schedules_all

1575: <> l_prior_payment_schedule_id) THEN
1576:
1577: l_prior_payment_schedule_id := exp_ap_cache(item).pn_payment_schedule_id;
1578:
1579: UPDATE pn_payment_schedules_all
1580: SET transferred_by_user_id = l_last_updated_by,
1581: transfer_date = l_last_update_date,
1582: last_updated_by = l_last_updated_by,
1583: last_update_login = l_last_update_login,

Line 2033: UPDATE pn_payment_schedules_all

2029: <> l_prior_payment_schedule_id ) THEN
2030:
2031: l_prior_payment_schedule_id := exp_ap_cache(item).pn_payment_schedule_id;
2032:
2033: UPDATE pn_payment_schedules_all
2034: SET transferred_by_user_id = l_last_updated_by,
2035: transfer_date = l_last_update_date,
2036: last_updated_by = l_last_updated_by,
2037: last_update_login = l_last_update_login,