APPS.JAI_CMN_RGM_SETUP_PKG dependencies on JAI_RGM_DOC_SEQ_HDRS

Line 41: FROM jai_rgm_doc_seq_hdrs rhdr

37: Reason:
38: Issue is with the following code in jai_cmn_rgm_setup_pkg.gen_invoice_num
39:
40: SELECT RGM_DOCUMENT_SEQ_ID
41: FROM jai_rgm_doc_seq_hdrs rhdr
42: WHERE rhdr.regime_id = p_regime_id
43: AND rhdr.party_id = p_organization_id
44: AND rhdr.party_site_id = p_location_id
45: AND TRUNC(p_date) between TRUNC(rhdr.effective_from) and

Line 82: FROM jai_rgm_doc_seq_hdrs rhdr

78: p_location_id hr_locations.location_id%Type ,
79: p_date DATE
80: ) IS
81: SELECT RGM_DOCUMENT_SEQ_ID
82: FROM jai_rgm_doc_seq_hdrs rhdr
83: WHERE rhdr.regime_id = p_regime_id
84: AND rhdr.party_id = p_organization_id
85: AND rhdr.party_site_id = p_location_id
86: -- AND TRUNC(p_date) between TRUNC(rhdr.effective_from) and NVL(TRUNC(rhdr.effective_to) ,sysdate) ;

Line 94: FROM jai_rgm_doc_seq_hdrs rhdr

90: ln_regnum JAI_RGM_REGISTRATIONS.attribute_value%Type,
91: p_date DATE
92: ) IS
93: SELECT rgm_document_seq_id
94: FROM jai_rgm_doc_seq_hdrs rhdr
95: WHERE rhdr.regime_id = p_regime_id
96: AND rhdr.registration_num = ln_regnum
97: -- AND TRUNC(p_date) between TRUNC(rhdr.effective_from) and NVL(TRUNC(rhdr.effective_to) ,sysdate) ;
98: AND TRUNC(p_date) between TRUNC(rhdr.effective_from) and NVL(TRUNC(rhdr.effective_to) ,TRUNC(p_date)) ; --changed the sysdate default value to TRUNC(p_date) for bug#8667957

Line 115: CURSOR c_rgm_dtl(ln_seq_id jai_rgm_doc_seq_hdrs.rgm_document_seq_id%Type,

111: and attribute_type_Code = p_att_type_code
112: and attribute_code = p_att_code ;
113:
114:
115: CURSOR c_rgm_dtl(ln_seq_id jai_rgm_doc_seq_hdrs.rgm_document_seq_id%Type,
116: p_doc_class jai_rgm_doc_seq_dtls.document_class%Type,
117: p_doc_type_id jai_rgm_doc_seq_dtls.document_class_Type_id%Type
118: ) IS
119: SELECT rgm_document_seq_dtl_id