APPS.PA_BILLING_SETUP_UTILS dependencies on PA_INVOICE_FORMATS

Line 39: FROM pa_invoice_formats

35:
36: CURSOR c_ids
37: IS
38: SELECT invoice_format_id
39: FROM pa_invoice_formats
40: WHERE name = p_retention_inv_format_name;
41:
42: BEGIN
43: IF p_retention_inv_format_id IS NOT NULL

Line 49: FROM pa_invoice_formats

45: IF p_check_id_flag = 'Y'
46: THEN
47: SELECT invoice_format_id
48: INTO x_retention_inv_format_id
49: FROM pa_invoice_formats
50: WHERE invoice_format_id = p_retention_inv_format_id;
51: ELSIF p_check_id_flag = 'N'
52: THEN
53: x_retention_inv_format_id := p_retention_inv_format_id;

Line 90: FROM pa_invoice_formats

86: IF p_retention_inv_format_name IS NOT NULL
87: THEN
88: SELECT invoice_format_id
89: INTO x_retention_inv_format_id
90: FROM pa_invoice_formats
91: WHERE name = p_retention_inv_format_name;
92: ELSE
93: x_retention_inv_format_id := null;
94: END IF;