APPS.GR_PROCESS_ORDERS dependencies on GR_RECIPIENT_INFO

Line 1836: FROM gr_recipient_info ri

1832: */
1833: CURSOR c_get_recipient
1834: IS
1835: SELECT ri.recipient_code
1836: FROM gr_recipient_info ri
1837: WHERE ri.recipient_code = BatchDetails.recipient_code;
1838: LocalRecipientRecord c_get_recipient%ROWTYPE;
1839: /*
1840: ** Get the customer name from the OPM Customer table

Line 1894: t_recipient_code GR_RECIPIENT_INFO.RECIPIENT_CODE%TYPE;

1890: GenericRecord c_get_generic_item%ROWTYPE;
1891:
1892: l_item_code GR_ITEM_GENERAL.ITEM_CODE%TYPE;
1893: t_item_code GR_ITEM_GENERAL.ITEM_CODE%TYPE;
1894: t_recipient_code GR_RECIPIENT_INFO.RECIPIENT_CODE%TYPE;
1895:
1896: /*
1897: ** Bug 2342375 Mercy Thomas 08/15/2002 End the code changes
1898: */

Line 1993: GR_RECIPIENT_INFO_PKG.Insert_Row

1989: l_code_block := 'No customer info';
1990: END IF; /* c_get_customer_name Not Found */
1991: CLOSE c_get_customer_name;
1992:
1993: GR_RECIPIENT_INFO_PKG.Insert_Row
1994: (l_commit,
1995: l_called_by_form,
1996: BatchDetails.recipient_code,
1997: LocalCustRecord.cust_name,

Line 2434: FROM gr_recipient_info ri,

2430: ri.invoice_address,
2431: ri.additional_address_flag,
2432: cp.language,
2433: cp.document_code country_document
2434: FROM gr_recipient_info ri,
2435: gr_country_profiles cp
2436: WHERE ri.recipient_code >= p_recipient_from
2437: AND ri.recipient_code <= p_recipient_to
2438: AND ri.territory_code = cp.territory_code;

Line 3934: FROM gr_recipient_info

3930: gr_selection sd
3931: WHERE ( (sd.order_no = g_order_number /* Same order and line number */
3932: AND sd.order_line_number = g_order_line)
3933: OR ( (NOT EXISTS (SELECT 1
3934: FROM gr_recipient_info
3935: WHERE recipient_code = g_recipient_code)
3936: -- AND document_print_frequency = 'A')
3937: OR sh.batch_no = g_batch_number
3938: )