377: wsh.category_code,
378: fnd.method_code
379: FROM
380: wsh_doc_sequence_categories wsh
381: , fnd_doc_sequence_assignments fnd
382: WHERE wsh.document_type = p_document_type
383: AND wsh.enabled_flag = 'Y'
384: AND ( (wsh.location_id = p_location_id AND
385: wsh.document_code = p_document_code)
1066: SELECT
1067: method_code,
1068: doc_sequence_id
1069: FROM
1070: fnd_doc_sequence_assignments
1071: WHERE application_id = p_application_id
1072: AND set_of_books_id = p_ledger_id
1073: AND category_code = c_category_code
1074: AND start_date <= sysdate