DBA Data[Home] [Help]

APPS.PA_CAPITALIZED_INTEREST dependencies on PA_CINT_RATE_MULTIPLIERS

Line 84: delete pa_cint_rate_multipliers

80: -- Whenever user recompiles the schedule by making changes for the rate structure,
81: -- the compilation process will blow off the de normalized records for the given
82: -- schedule revision from the pa_cint_rate_multiplers table and create new records.
83:
84: delete pa_cint_rate_multipliers
85: where ind_rate_sch_revision_id = l_ind_rate_sch_rev_id;
86:
87: -- When deleted the records from multipliers in the Burden Schedules form,
88: -- the pa_ind_cost_multipliers.ready_to_compile_flag is marked with X but not

Line 255: INSERT INTO pa_cint_rate_multipliers

251: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
252: l_program_application_id := FND_GLOBAL.PROG_APPL_ID;
253: l_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
254:
255: INSERT INTO pa_cint_rate_multipliers
256: (IND_RATE_SCH_REVISION_ID,
257: ORGANIZATION_ID,
258: IND_RATE_SCH_ID,
259: RATE_NAME,

Line 302: from pa_cint_rate_multipliers icm

298: l_request_id,
299: l_program_application_id,
300: l_program_id,
301: SYSDATE
302: from pa_cint_rate_multipliers icm
303: where icm.ind_rate_sch_revision_id = p_rate_sch_rev_id
304: and icm.organization_id = p_org_id_parent
305: and icm.rate_name not in (select cm1.ind_cost_code
306: from pa_ind_cost_multipliers cm1