APPS.PSB_HR_POPULATE_DATA_PVT dependencies on PSB_COST_DISTRIBUTIONS_I

Line 4372: description psb_cost_distributions_i.description%TYPE,

4368: award_id NUMBER,
4369: expenditure_type VARCHAR2(30),
4370: expenditure_org_id NUMBER,
4371: --UTF8 changes for Bug No : 2615261
4372: description psb_cost_distributions_i.description%TYPE,
4373: cost_allocation_keyflex_id NUMBER,
4374: segment1 VARCHAR2(25), segment2 VARCHAR2(25), segment3 VARCHAR2(25),
4375: segment4 VARCHAR2(25), segment5 VARCHAR2(25), segment6 VARCHAR2(25),
4376: segment7 VARCHAR2(25), segment8 VARCHAR2(25), segment9 VARCHAR2(25),

Line 4404: l_description psb_cost_distributions_i.description%TYPE;

4400: l_expenditure_org_id NUMBER(15);
4401: l_error_message VARCHAR2(100);
4402:
4403: -- UTF8 changes for Bug No : 2615261
4404: l_description psb_cost_distributions_i.description%TYPE;
4405: l_position_name VARCHAR2(240);
4406: l_process_start_date DATE;
4407: l_default_start_date DATE := fnd_date.canonical_to_date('1941/01/01');
4408: l_rep_req_id NUMBER;

Line 4511: FROM psb_cost_distributions_i a,

4507: a.segment16, a.segment17, a.segment18, a.segment19, a.segment20,
4508: a.segment21, a.segment22, a.segment23, a.segment24, a.segment25,
4509: a.segment26, a.segment27, a.segment28, a.segment29, a.segment30,
4510: a.effective_start_date
4511: FROM psb_cost_distributions_i a,
4512: psb_employees_i b,
4513: psb_employees be,
4514: psb_positions c,
4515: psb_position_assignments d

Line 5472: -- Bug#3467512: As psb_cost_distributions_i is open interface table, it can

5468: l_default_start_date),
5469: p_position_start_date);
5470:
5471: --
5472: -- Bug#3467512: As psb_cost_distributions_i is open interface table, it can
5473: -- be populated with duplicate records where CCID and Effective start dates
5474: -- are same but percent is different as reported in bug. To fix this, we
5475: -- need to consolidate percent by CCID and Effective start date.
5476: --