APPS.PN_EXP_TO_AP dependencies on PN_PAYMENT_TERMS

Line 67: ,pn_project_id PN_PAYMENT_TERMS.project_id%TYPE

63: ,pn_export_currency_amount PN_PAYMENT_ITEMS.export_currency_amount%TYPE
64: ,pn_export_currency_code PN_PAYMENT_ITEMS.export_currency_code%TYPE
65: ,pn_vendor_id PN_PAYMENT_ITEMS.vendor_id%TYPE
66: ,pn_vendor_site_id PN_PAYMENT_ITEMS.vendor_site_id%TYPE
67: ,pn_project_id PN_PAYMENT_TERMS.project_id%TYPE
68: ,pn_task_id PN_PAYMENT_TERMS.task_id%TYPE
69: ,pn_organization_id PN_PAYMENT_TERMS.organization_id%TYPE
70: ,pn_expenditure_type PN_PAYMENT_TERMS.expenditure_type%TYPE
71: ,pn_expenditure_item_date PN_PAYMENT_TERMS.expenditure_item_date%TYPE

Line 68: ,pn_task_id PN_PAYMENT_TERMS.task_id%TYPE

64: ,pn_export_currency_code PN_PAYMENT_ITEMS.export_currency_code%TYPE
65: ,pn_vendor_id PN_PAYMENT_ITEMS.vendor_id%TYPE
66: ,pn_vendor_site_id PN_PAYMENT_ITEMS.vendor_site_id%TYPE
67: ,pn_project_id PN_PAYMENT_TERMS.project_id%TYPE
68: ,pn_task_id PN_PAYMENT_TERMS.task_id%TYPE
69: ,pn_organization_id PN_PAYMENT_TERMS.organization_id%TYPE
70: ,pn_expenditure_type PN_PAYMENT_TERMS.expenditure_type%TYPE
71: ,pn_expenditure_item_date PN_PAYMENT_TERMS.expenditure_item_date%TYPE
72: ,pn_tax_group_id PN_PAYMENT_TERMS.tax_group_id%TYPE

Line 69: ,pn_organization_id PN_PAYMENT_TERMS.organization_id%TYPE

65: ,pn_vendor_id PN_PAYMENT_ITEMS.vendor_id%TYPE
66: ,pn_vendor_site_id PN_PAYMENT_ITEMS.vendor_site_id%TYPE
67: ,pn_project_id PN_PAYMENT_TERMS.project_id%TYPE
68: ,pn_task_id PN_PAYMENT_TERMS.task_id%TYPE
69: ,pn_organization_id PN_PAYMENT_TERMS.organization_id%TYPE
70: ,pn_expenditure_type PN_PAYMENT_TERMS.expenditure_type%TYPE
71: ,pn_expenditure_item_date PN_PAYMENT_TERMS.expenditure_item_date%TYPE
72: ,pn_tax_group_id PN_PAYMENT_TERMS.tax_group_id%TYPE
73: ,pn_tax_code_id PN_PAYMENT_TERMS.tax_code_id%TYPE

Line 70: ,pn_expenditure_type PN_PAYMENT_TERMS.expenditure_type%TYPE

66: ,pn_vendor_site_id PN_PAYMENT_ITEMS.vendor_site_id%TYPE
67: ,pn_project_id PN_PAYMENT_TERMS.project_id%TYPE
68: ,pn_task_id PN_PAYMENT_TERMS.task_id%TYPE
69: ,pn_organization_id PN_PAYMENT_TERMS.organization_id%TYPE
70: ,pn_expenditure_type PN_PAYMENT_TERMS.expenditure_type%TYPE
71: ,pn_expenditure_item_date PN_PAYMENT_TERMS.expenditure_item_date%TYPE
72: ,pn_tax_group_id PN_PAYMENT_TERMS.tax_group_id%TYPE
73: ,pn_tax_code_id PN_PAYMENT_TERMS.tax_code_id%TYPE
74: ,pn_tax_classification_code PN_PAYMENT_TERMS.tax_classification_code%TYPE

Line 71: ,pn_expenditure_item_date PN_PAYMENT_TERMS.expenditure_item_date%TYPE

67: ,pn_project_id PN_PAYMENT_TERMS.project_id%TYPE
68: ,pn_task_id PN_PAYMENT_TERMS.task_id%TYPE
69: ,pn_organization_id PN_PAYMENT_TERMS.organization_id%TYPE
70: ,pn_expenditure_type PN_PAYMENT_TERMS.expenditure_type%TYPE
71: ,pn_expenditure_item_date PN_PAYMENT_TERMS.expenditure_item_date%TYPE
72: ,pn_tax_group_id PN_PAYMENT_TERMS.tax_group_id%TYPE
73: ,pn_tax_code_id PN_PAYMENT_TERMS.tax_code_id%TYPE
74: ,pn_tax_classification_code PN_PAYMENT_TERMS.tax_classification_code%TYPE
75: ,pn_tax_included PN_PAYMENT_TERMS.tax_included%TYPE

Line 72: ,pn_tax_group_id PN_PAYMENT_TERMS.tax_group_id%TYPE

68: ,pn_task_id PN_PAYMENT_TERMS.task_id%TYPE
69: ,pn_organization_id PN_PAYMENT_TERMS.organization_id%TYPE
70: ,pn_expenditure_type PN_PAYMENT_TERMS.expenditure_type%TYPE
71: ,pn_expenditure_item_date PN_PAYMENT_TERMS.expenditure_item_date%TYPE
72: ,pn_tax_group_id PN_PAYMENT_TERMS.tax_group_id%TYPE
73: ,pn_tax_code_id PN_PAYMENT_TERMS.tax_code_id%TYPE
74: ,pn_tax_classification_code PN_PAYMENT_TERMS.tax_classification_code%TYPE
75: ,pn_tax_included PN_PAYMENT_TERMS.tax_included%TYPE
76: ,pn_distribution_set_id PN_PAYMENT_TERMS.distribution_set_id%TYPE

Line 73: ,pn_tax_code_id PN_PAYMENT_TERMS.tax_code_id%TYPE

69: ,pn_organization_id PN_PAYMENT_TERMS.organization_id%TYPE
70: ,pn_expenditure_type PN_PAYMENT_TERMS.expenditure_type%TYPE
71: ,pn_expenditure_item_date PN_PAYMENT_TERMS.expenditure_item_date%TYPE
72: ,pn_tax_group_id PN_PAYMENT_TERMS.tax_group_id%TYPE
73: ,pn_tax_code_id PN_PAYMENT_TERMS.tax_code_id%TYPE
74: ,pn_tax_classification_code PN_PAYMENT_TERMS.tax_classification_code%TYPE
75: ,pn_tax_included PN_PAYMENT_TERMS.tax_included%TYPE
76: ,pn_distribution_set_id PN_PAYMENT_TERMS.distribution_set_id%TYPE
77: ,pn_lease_num PN_LEASES.lease_num%TYPE

Line 74: ,pn_tax_classification_code PN_PAYMENT_TERMS.tax_classification_code%TYPE

70: ,pn_expenditure_type PN_PAYMENT_TERMS.expenditure_type%TYPE
71: ,pn_expenditure_item_date PN_PAYMENT_TERMS.expenditure_item_date%TYPE
72: ,pn_tax_group_id PN_PAYMENT_TERMS.tax_group_id%TYPE
73: ,pn_tax_code_id PN_PAYMENT_TERMS.tax_code_id%TYPE
74: ,pn_tax_classification_code PN_PAYMENT_TERMS.tax_classification_code%TYPE
75: ,pn_tax_included PN_PAYMENT_TERMS.tax_included%TYPE
76: ,pn_distribution_set_id PN_PAYMENT_TERMS.distribution_set_id%TYPE
77: ,pn_lease_num PN_LEASES.lease_num%TYPE
78: ,pn_lease_id PN_LEASES.lease_id%TYPE

Line 75: ,pn_tax_included PN_PAYMENT_TERMS.tax_included%TYPE

71: ,pn_expenditure_item_date PN_PAYMENT_TERMS.expenditure_item_date%TYPE
72: ,pn_tax_group_id PN_PAYMENT_TERMS.tax_group_id%TYPE
73: ,pn_tax_code_id PN_PAYMENT_TERMS.tax_code_id%TYPE
74: ,pn_tax_classification_code PN_PAYMENT_TERMS.tax_classification_code%TYPE
75: ,pn_tax_included PN_PAYMENT_TERMS.tax_included%TYPE
76: ,pn_distribution_set_id PN_PAYMENT_TERMS.distribution_set_id%TYPE
77: ,pn_lease_num PN_LEASES.lease_num%TYPE
78: ,pn_lease_id PN_LEASES.lease_id%TYPE
79: ,pn_send_entries PN_LEASE_DETAILS.send_entries%TYPE

Line 76: ,pn_distribution_set_id PN_PAYMENT_TERMS.distribution_set_id%TYPE

72: ,pn_tax_group_id PN_PAYMENT_TERMS.tax_group_id%TYPE
73: ,pn_tax_code_id PN_PAYMENT_TERMS.tax_code_id%TYPE
74: ,pn_tax_classification_code PN_PAYMENT_TERMS.tax_classification_code%TYPE
75: ,pn_tax_included PN_PAYMENT_TERMS.tax_included%TYPE
76: ,pn_distribution_set_id PN_PAYMENT_TERMS.distribution_set_id%TYPE
77: ,pn_lease_num PN_LEASES.lease_num%TYPE
78: ,pn_lease_id PN_LEASES.lease_id%TYPE
79: ,pn_send_entries PN_LEASE_DETAILS.send_entries%TYPE
80: ,pn_payment_schedule_id PN_PAYMENT_ITEMS.payment_schedule_id%TYPE

Line 83: ,pn_normalize PN_PAYMENT_TERMS.normalize%TYPE

79: ,pn_send_entries PN_LEASE_DETAILS.send_entries%TYPE
80: ,pn_payment_schedule_id PN_PAYMENT_ITEMS.payment_schedule_id%TYPE
81: ,pn_period_name PN_PAYMENT_SCHEDULES.period_name%TYPE
82: ,gl_date DATE
83: ,pn_normalize PN_PAYMENT_TERMS.normalize%TYPE
84: ,pn_due_date PN_PAYMENT_ITEMS.due_date%TYPE
85: ,pn_ap_ar_term_id PN_PAYMENT_TERMS.ap_ar_term_id%TYPE
86: ,pn_accounted_date PN_PAYMENT_ITEMS.accounted_date%TYPE
87: ,pn_rate PN_PAYMENT_ITEMS.rate%TYPE

Line 85: ,pn_ap_ar_term_id PN_PAYMENT_TERMS.ap_ar_term_id%TYPE

81: ,pn_period_name PN_PAYMENT_SCHEDULES.period_name%TYPE
82: ,gl_date DATE
83: ,pn_normalize PN_PAYMENT_TERMS.normalize%TYPE
84: ,pn_due_date PN_PAYMENT_ITEMS.due_date%TYPE
85: ,pn_ap_ar_term_id PN_PAYMENT_TERMS.ap_ar_term_id%TYPE
86: ,pn_accounted_date PN_PAYMENT_ITEMS.accounted_date%TYPE
87: ,pn_rate PN_PAYMENT_ITEMS.rate%TYPE
88: ,pn_ap_invoice_num PN_PAYMENT_ITEMS.ap_invoice_num%TYPE
89: ,pn_payment_purpose_code PN_PAYMENT_TERMS.payment_purpose_code%TYPE

Line 89: ,pn_payment_purpose_code PN_PAYMENT_TERMS.payment_purpose_code%TYPE

85: ,pn_ap_ar_term_id PN_PAYMENT_TERMS.ap_ar_term_id%TYPE
86: ,pn_accounted_date PN_PAYMENT_ITEMS.accounted_date%TYPE
87: ,pn_rate PN_PAYMENT_ITEMS.rate%TYPE
88: ,pn_ap_invoice_num PN_PAYMENT_ITEMS.ap_invoice_num%TYPE
89: ,pn_payment_purpose_code PN_PAYMENT_TERMS.payment_purpose_code%TYPE
90: ,pn_payment_term_type_code PN_PAYMENT_TERMS.payment_term_type_code%TYPE
91: ,pn_lia_account PN_DISTRIBUTIONS.account_id%TYPE
92: ,pn_legal_entity_id PN_PAYMENT_TERMS.legal_entity_id%TYPE
93: ,conv_rate PN_PAYMENT_ITEMS.rate%TYPE

Line 90: ,pn_payment_term_type_code PN_PAYMENT_TERMS.payment_term_type_code%TYPE

86: ,pn_accounted_date PN_PAYMENT_ITEMS.accounted_date%TYPE
87: ,pn_rate PN_PAYMENT_ITEMS.rate%TYPE
88: ,pn_ap_invoice_num PN_PAYMENT_ITEMS.ap_invoice_num%TYPE
89: ,pn_payment_purpose_code PN_PAYMENT_TERMS.payment_purpose_code%TYPE
90: ,pn_payment_term_type_code PN_PAYMENT_TERMS.payment_term_type_code%TYPE
91: ,pn_lia_account PN_DISTRIBUTIONS.account_id%TYPE
92: ,pn_legal_entity_id PN_PAYMENT_TERMS.legal_entity_id%TYPE
93: ,conv_rate PN_PAYMENT_ITEMS.rate%TYPE
94: ,conv_rate_type PN_CURRENCIES.conversion_type%TYPE

Line 92: ,pn_legal_entity_id PN_PAYMENT_TERMS.legal_entity_id%TYPE

88: ,pn_ap_invoice_num PN_PAYMENT_ITEMS.ap_invoice_num%TYPE
89: ,pn_payment_purpose_code PN_PAYMENT_TERMS.payment_purpose_code%TYPE
90: ,pn_payment_term_type_code PN_PAYMENT_TERMS.payment_term_type_code%TYPE
91: ,pn_lia_account PN_DISTRIBUTIONS.account_id%TYPE
92: ,pn_legal_entity_id PN_PAYMENT_TERMS.legal_entity_id%TYPE
93: ,conv_rate PN_PAYMENT_ITEMS.rate%TYPE
94: ,conv_rate_type PN_CURRENCIES.conversion_type%TYPE
95: ,item_grouping_rule_id PN_PAYMENT_ITEMS.grouping_rule_id%TYPE
96: ,term_grouping_rule_id PN_PAYMENT_TERMS.grouping_rule_id%TYPE

Line 96: ,term_grouping_rule_id PN_PAYMENT_TERMS.grouping_rule_id%TYPE

92: ,pn_legal_entity_id PN_PAYMENT_TERMS.legal_entity_id%TYPE
93: ,conv_rate PN_PAYMENT_ITEMS.rate%TYPE
94: ,conv_rate_type PN_CURRENCIES.conversion_type%TYPE
95: ,item_grouping_rule_id PN_PAYMENT_ITEMS.grouping_rule_id%TYPE
96: ,term_grouping_rule_id PN_PAYMENT_TERMS.grouping_rule_id%TYPE
97: ,lease_grouping_rule_id PN_LEASE_DETAILS.grouping_rule_id%TYPE
98: ,processed VARCHAR2(1));
99:
100: -- export items cache table type