APPS.PA_ONLINE_COPY_EXP dependencies on PA_EI_DENORM

Line 77: pa_ei_denorm_s.nextval denorm_id,

73:
74: CURSOR getEIdenorm IS
75: SELECT
76: x_new_exp_id expenditure_id,
77: pa_ei_denorm_s.nextval denorm_id,
78: G_inc_by_person_id person_id,
79: project_id,
80: task_id,
81: billable_flag,

Line 696: pa_ei_denorm

692: decode(G_copy_exp_type_flag,'Y',
693: decode(G_copy_qty_flag,'Y',job_id_7,
694: l_dummy),l_dummy),l_dummy) job_id_7
695: FROM
696: pa_ei_denorm
697: WHERE expenditure_id = x_orig_exp_id;
698:
699: ei_denorm getEIdenorm%ROWTYPE;
700:

Line 1219: -- Insert denorm record into pa_ei_denorm regards if any quantities got thru or not.

1215: ei_denorm.denorm_total_amount := null;
1216: x_total_exp_copied := x_total_exp_copied + nvl(ei_denorm.denorm_total_qty,0);
1217: END IF;
1218:
1219: -- Insert denorm record into pa_ei_denorm regards if any quantities got thru or not.
1220: pa_online_exp.insert_pa_ei_denorm_rec(
1221: ei_denorm.expenditure_id,
1222: ei_denorm.denorm_id,
1223: ei_denorm.person_id,

Line 1220: pa_online_exp.insert_pa_ei_denorm_rec(

1216: x_total_exp_copied := x_total_exp_copied + nvl(ei_denorm.denorm_total_qty,0);
1217: END IF;
1218:
1219: -- Insert denorm record into pa_ei_denorm regards if any quantities got thru or not.
1220: pa_online_exp.insert_pa_ei_denorm_rec(
1221: ei_denorm.expenditure_id,
1222: ei_denorm.denorm_id,
1223: ei_denorm.person_id,
1224: ei_denorm.project_id,

Line 1638: FROM PA_EI_DENORM

1634: SELECT 'Y'
1635: INTO x_return
1636: FROM SYS.DUAL
1637: WHERE EXISTS (SELECT 'x'
1638: FROM PA_EI_DENORM
1639: WHERE EXPENDITURE_ID = x_orig_exp_id);
1640:
1641: RETURN ( x_return ) ;
1642: