APPS.IGC_CC_YEP_PROCESS_PKG dependencies on FND_APPLICATION

Line 79: l_application_id fnd_application.application_id%TYPE;

75: l_msg_count NUMBER;
76: l_msg_data VARCHAR2(2000);
77: G_FLAG VARCHAR2(1);
78: l_CC_VERSION_NUM IGC_CC_HEADERS.CC_VERSION_NUM%TYPE;
79: l_application_id fnd_application.application_id%TYPE;
80: l_APPROVAL_STATUS IGC_CC_HEADERS.CC_APPRVL_STATUS%TYPE;
81: l_PROVISIONAL_COUNTER NUMBER;
82: l_CC_ACCT_DATE DATE;
83: l_cc_acct_encmbrnc_date igc_cc_acct_lines.cc_acct_encmbrnc_date%TYPE;

Line 105: FROM fnd_application

101: SAVEPOINT S1;
102:
103: SELECT application_id
104: INTO l_application_id
105: FROM fnd_application
106: WHERE application_short_name = 'SQLGL';
107:
108:
109: SELECT CC_STATE,CC_ENCMBRNC_STATUS

Line 1028: FROM FND_APPLICATION

1024: p_period_num NUMBER) IS
1025: SELECT PERIOD_NAME, PERIOD_NUM, CLOSING_STATUS
1026: FROM GL_PERIOD_STATUSES
1027: WHERE APPLICATION_ID = (SELECT APPLICATION_ID
1028: FROM FND_APPLICATION
1029: WHERE APPLICATION_SHORT_NAME = 'SQLGL')
1030: -- Bug No : 6341012. MOAC Uptake. p_sob_id is changed to l_sob_id
1031: AND SET_OF_BOOKS_ID = l_sob_id
1032: AND ADJUSTMENT_PERIOD_FLAG = 'N'

Line 1044: FROM FND_APPLICATION

1040: CURSOR C9 IS
1041: SELECT PERIOD_NAME, PERIOD_NUM, CLOSING_STATUS
1042: FROM GL_PERIOD_STATUSES
1043: WHERE APPLICATION_ID = (SELECT APPLICATION_ID
1044: FROM FND_APPLICATION
1045: WHERE APPLICATION_SHORT_NAME = 'SQLGL')
1046:
1047: AND PERIOD_YEAR = p_YEAR
1048: -- Bug No : 6341012. MOAC Uptake. p_sob_id is changed to l_sob_id

Line 1108: l_application_id fnd_application.application_id%TYPE;

1104: l_invalid_counter NUMBER;
1105:
1106: /********************** ENCUMBRANCE DECLARATION *******************/
1107:
1108: l_application_id fnd_application.application_id%TYPE;
1109: l_yr_start_date DATE;
1110: l_yr_start_date_next DATE;
1111: l_yr_end_date DATE;
1112: l_yr_end_cr_date DATE;

Line 1340: FROM fnd_application

1336: /******************** ENCUMBRANCE CODE *******************/
1337:
1338: SELECT application_id
1339: INTO l_application_id
1340: FROM fnd_application
1341: WHERE application_short_name = 'SQLGL';
1342:
1343:
1344: l_min_period_num := NULL;