DBA Data[Home] [Help]

APPS.MSC_REPPERIODS_PUB dependencies on MSC_PARAMETERS

Line 12: param msc_parameters%ROWTYPE;

8: | Variable delarations |
9: +---------------------------*/
10: var_calendar_code VARCHAR2(14);
11: var_exception_set_id NUMBER;
12: param msc_parameters%ROWTYPE;
13: var_max_date DATE;
14: var_curr_date DATE;
15: var_curr_bucket NUMBER := 1;
16: var_end_date1 DATE;

Line 37: FROM msc_parameters

33:
34: -- Select the organization information
35: SELECT *
36: INTO param
37: FROM msc_parameters
38: WHERE organization_id = arg_org_id
39: AND sr_instance_id = arg_instance_id;
40:
41: -- Select the calendar code and exception set id for this org