APPS.GMS_PA_API3 dependencies on PA_IND_RATE_SCH_REVISIONS

Line 1082: FROM pa_ind_rate_sch_revisions irsr,

1078: null,
1079: to_number(null),
1080: 'N',
1081: null
1082: FROM pa_ind_rate_sch_revisions irsr,
1083: pa_cost_base_exp_types cbet,
1084: pa_compiled_multipliers cm,
1085: pa_ind_cost_codes icc,
1086: pa_ind_rate_schedules_all_bg irs,

Line 1656: FROM pa_ind_rate_sch_revisions irsr,

1652: null,
1653: to_number(null),
1654: 'N',
1655: null
1656: FROM pa_ind_rate_sch_revisions irsr,
1657: pa_cost_base_exp_types cbet,
1658: pa_compiled_multipliers cm,
1659: pa_ind_cost_codes icc,
1660: pa_ind_rate_schedules_all_bg irs,

Line 2260: FROM pa_ind_rate_sch_revisions irsr,

2256: null,
2257: to_number(null),
2258: 'N',
2259: null
2260: FROM pa_ind_rate_sch_revisions irsr,
2261: pa_cost_base_exp_types cbet,
2262: pa_compiled_multipliers cm,
2263: pa_ind_cost_codes icc,
2264: pa_ind_rate_schedules_all_bg irs,

Line 2594: from pa_ind_rate_sch_revisions irsr

2590: begin
2591: l_test := 0;
2592: select 1
2593: into l_test
2594: from pa_ind_rate_sch_revisions irsr
2595: where irsr.ind_rate_sch_id = p_ind_rate_sch_id
2596: and end_date_active is null;
2597: exception
2598: when no_data_found then

Line 2605: from pa_ind_rate_sch_revisions irsr

2601:
2602: if l_test = 0 then
2603: select min(start_date_active), max(end_date_active)
2604: into l_start_date_min, l_end_date_max
2605: from pa_ind_rate_sch_revisions irsr
2606: where irsr.ind_rate_sch_id = p_ind_rate_sch_id;
2607: else
2608: select min(start_date_active)
2609: into l_start_date_min

Line 2610: from pa_ind_rate_sch_revisions irsr

2606: where irsr.ind_rate_sch_id = p_ind_rate_sch_id;
2607: else
2608: select min(start_date_active)
2609: into l_start_date_min
2610: from pa_ind_rate_sch_revisions irsr
2611: where irsr.ind_rate_sch_id = p_ind_rate_sch_id;
2612: end if;
2613:
2614: if p_calling_form = 'GMSICOVR' then -- call from override schedule screen

Line 2662: pa_ind_rate_sch_revisions irsr

2658: AND ITEM.ind_compiled_set_id is not null
2659: AND 1 = decode(p_event, 'INSERT', 1
2660: , (select 1
2661: from pa_ind_compiled_sets ics,
2662: pa_ind_rate_sch_revisions irsr
2663: where ITEM.ind_compiled_set_id = ics.ind_compiled_set_id
2664: and ics.ind_rate_sch_revision_id = irsr.ind_rate_sch_revision_id
2665: and irsr.ind_rate_sch_id = p_ind_rate_sch_id
2666: and rownum = 1));

Line 2756: pa_ind_rate_sch_revisions irsr

2752: AND ITEM.ind_compiled_set_id is not null
2753: AND 1 = decode(p_event, 'INSERT', 1
2754: , (select 1
2755: from pa_ind_compiled_sets ics,
2756: pa_ind_rate_sch_revisions irsr
2757: where ITEM.ind_compiled_set_id = ics.ind_compiled_set_id
2758: and ics.ind_rate_sch_revision_id = irsr.ind_rate_sch_revision_id
2759: and irsr.ind_rate_sch_id = p_ind_rate_sch_id
2760: and rownum = 1));