APPS.JAI_CMN_RGM_SETUP_PKG dependencies on JAI_RGM_DOC_SEQ_HDRS

Line 54: FROM jai_rgm_doc_seq_hdrs rhdr

50: p_location_id hr_locations.location_id%Type ,
51: p_date DATE
52: ) IS
53: SELECT RGM_DOCUMENT_SEQ_ID
54: FROM jai_rgm_doc_seq_hdrs rhdr
55: WHERE rhdr.regime_id = p_regime_id
56: AND rhdr.party_id = p_organization_id
57: AND rhdr.party_site_id = p_location_id
58: AND TRUNC(p_date) between TRUNC(rhdr.effective_from) and NVL(TRUNC(rhdr.effective_to) ,sysdate) ;

Line 65: FROM jai_rgm_doc_seq_hdrs rhdr

61: ln_regnum JAI_RGM_REGISTRATIONS.attribute_value%Type,
62: p_date DATE
63: ) IS
64: SELECT rgm_document_seq_id
65: FROM jai_rgm_doc_seq_hdrs rhdr
66: WHERE rhdr.regime_id = p_regime_id
67: AND rhdr.registration_num = ln_regnum
68: AND TRUNC(p_date) between TRUNC(rhdr.effective_from) and NVL(TRUNC(rhdr.effective_to) ,sysdate) ;
69:

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

81: and attribute_type_Code = p_att_type_code
82: and attribute_code = p_att_code ;
83:
84:
85: CURSOR c_rgm_dtl(ln_seq_id jai_rgm_doc_seq_hdrs.rgm_document_seq_id%Type,
86: p_doc_class jai_rgm_doc_seq_dtls.document_class%Type,
87: p_doc_type_id jai_rgm_doc_seq_dtls.document_class_Type_id%Type
88: ) IS
89: SELECT rgm_document_seq_dtl_id