APPS.JA_CN_GL_BANK_EXP_PKG dependencies on GL_PERIOD_STATUSES

Line 431: FROM GL_PERIOD_STATUSES

427: --Fetch start date and end date
428: IF pv_start IS NOT NULL THEN
429: SELECT start_date
430: INTO l_start_date
431: FROM GL_PERIOD_STATUSES
432: WHERE ledger_id = pn_ledger_id
433: AND application_id = 101
434: AND period_name = pv_start
435: AND TO_CHAR(period_year) = pv_accounting_year;

Line 443: FROM GL_PERIOD_STATUSES

439:
440: IF pv_start IS NOT NULL THEN
441: SELECT end_date
442: INTO l_end_date
443: FROM GL_PERIOD_STATUSES
444: WHERE ledger_id = pn_ledger_id
445: AND application_id = 101
446: AND period_name = pv_end
447: AND TO_CHAR(period_year) = pv_accounting_year;

Line 548: FROM GL_PERIOD_STATUSES

544: AND GBS.LEDGER_ID =pn_ledger_id
545: AND Ja_Cn_Utility.get_balancing_segment(GBS.CODE_COMBINATION_ID)=pv_bsv
546: AND PERIOD_NAME in
547: (SELECT period_name
548: FROM GL_PERIOD_STATUSES
549: WHERE ledger_id = pn_ledger_id
550: AND application_id = 101
551: AND ((start_date BETWEEN c_from AND c_to) AND
552: (end_date BETWEEN c_from AND c_to)))

Line 787: FROM GL_PERIOD_STATUSES

783: AND JA_CN_UTILITY.get_balancing_segment(GJL.CODE_COMBINATION_ID) = pv_bsv
784: AND GJH.LEDGER_ID = pn_ledger_id
785: AND GJH.PERIOD_NAME in
786: (SELECT period_name
787: FROM GL_PERIOD_STATUSES
788: WHERE ledger_id = pn_ledger_id
789: AND application_id = 101
790: AND ((start_date BETWEEN c_from AND c_to) AND
791: (end_date BETWEEN c_from AND c_to)))

Line 1022: FROM GL_PERIOD_STATUSES

1018: AND JA_CN_UTILITY.get_balancing_segment(GJL.CODE_COMBINATION_ID) = pv_bsv
1019: AND GJH.LEDGER_ID = pn_ledger_id
1020: AND GJH.PERIOD_NAME in
1021: (SELECT period_name
1022: FROM GL_PERIOD_STATUSES
1023: WHERE ledger_id = pn_ledger_id
1024: AND application_id = 101
1025: AND ((start_date BETWEEN c_from AND c_to) AND
1026: (end_date BETWEEN c_from AND c_to)))