APPS.GMS_PA_API3 dependencies on PA_IND_RATE_SCH_REVISIONS

Line 1084: FROM pa_ind_rate_sch_revisions irsr,

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

Line 1658: FROM pa_ind_rate_sch_revisions irsr,

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

Line 2262: FROM pa_ind_rate_sch_revisions irsr,

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

Line 2617: from pa_ind_rate_sch_revisions irsr

2613: begin
2614: l_test := 0;
2615: select 1
2616: into l_test
2617: from pa_ind_rate_sch_revisions irsr
2618: where irsr.ind_rate_sch_id = p_ind_rate_sch_id
2619: and end_date_active is null;
2620: exception
2621: when no_data_found then

Line 2628: from pa_ind_rate_sch_revisions irsr

2624:
2625: if l_test = 0 then
2626: select min(start_date_active), max(end_date_active)
2627: into l_start_date_min, l_end_date_max
2628: from pa_ind_rate_sch_revisions irsr
2629: where irsr.ind_rate_sch_id = p_ind_rate_sch_id;
2630: else
2631: select min(start_date_active)
2632: into l_start_date_min

Line 2633: from pa_ind_rate_sch_revisions irsr

2629: where irsr.ind_rate_sch_id = p_ind_rate_sch_id;
2630: else
2631: select min(start_date_active)
2632: into l_start_date_min
2633: from pa_ind_rate_sch_revisions irsr
2634: where irsr.ind_rate_sch_id = p_ind_rate_sch_id;
2635: end if;
2636:
2637: if p_calling_form = 'GMSICOVR' then -- call from override schedule screen

Line 2692: pa_ind_rate_sch_revisions irsr

2688: AND ITEM.ind_compiled_set_id > 0 -- bug 7225876
2689: AND 1 = decode(p_event, 'INSERT', 1
2690: , (select 1
2691: from pa_ind_compiled_sets ics,
2692: pa_ind_rate_sch_revisions irsr
2693: where ITEM.ind_compiled_set_id = ics.ind_compiled_set_id
2694: and ics.ind_rate_sch_revision_id = irsr.ind_rate_sch_revision_id
2695: and irsr.ind_rate_sch_id = p_ind_rate_sch_id
2696: and rownum = 1));

Line 2799: pa_ind_rate_sch_revisions irsr

2795: AND ITEM.ind_compiled_set_id > 0 -- bug 7225876
2796: AND 1 = decode(p_event, 'INSERT', 1
2797: , (select 1
2798: from pa_ind_compiled_sets ics,
2799: pa_ind_rate_sch_revisions irsr
2800: where ITEM.ind_compiled_set_id = ics.ind_compiled_set_id
2801: and ics.ind_rate_sch_revision_id = irsr.ind_rate_sch_revision_id
2802: and irsr.ind_rate_sch_id = p_ind_rate_sch_id
2803: and rownum = 1));