eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PSP_PAYTRN dependencies on PER_ASSIGNMENTS_F

Line 237: PER_ASSIGNMENTS_F b

233: SELECT a.assignment_id,
234: a.assignment_action_id,
235: b.person_id
236: FROM PAY_ASSIGNMENT_ACTIONS a,
237: PER_ASSIGNMENTS_F b
238: WHERE a.payroll_action_id = g_payroll_rec.payroll_action_id
239: and a.action_status = 'C'
240: and (a.assignment_id = b.assignment_id and
241: ((l_start_date between effective_start_date and effective_end_date) or

Line 1174: -- This procedure looks into per_assignments_f for assignment

1170: -- CREATE_WORKING_CALENDAR;
1171: create_working_calendar(l_assignment_id);
1172: g_no_of_person_work_days := g_no_of_work_days;
1173:
1174: -- This procedure looks into per_assignments_f for assignment
1175: -- end date. If the assignment end date falls in to the payroll period,
1176: -- it updates the array rows with 'N' for the rows after the assignment end date.
1177:
1178: hr_utility.trace(' UPDATE_WCAL_ASG_END_DATE');

Line 1194: -- This procedure looks into per_assignments_f for assignment

1190: l_error_api_name := 'UPDATE_WCAL_ASG_BEGIN_DATE : ';
1191: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1192: end if;
1193:
1194: -- This procedure looks into per_assignments_f for assignment
1195: -- status. If the assignment status is 'Suspend' or 'Terminate' for any of the days
1196: -- in the payroll period, it updates the working calendar array with 'N' for those days.
1197:
1198: hr_utility.trace(' UPDATE_WCAL_ASG_STATUS');

Line 1686: -- Looks in to per_assignments_f for assignment statuses either

1682: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1683: end if;
1684:
1685:
1686: -- Looks in to per_assignments_f for assignment statuses either
1687: -- 'Suspend' or 'Terminate' during the pay period.
1688: -- If found then split the sub-line in to two sub-lines and
1689: -- delete the existing sub-line.
1690:

Line 1715: -- Looks into per_assignments_f for Organization change during the pay period.

1711: ----dbms_output.PUT_LINE('...CREATE_SLINE_EMP_END_DATE :');
1712: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1713: end if;
1714:
1715: -- Looks into per_assignments_f for Organization change during the pay period.
1716: -- If found split the sub-line into two sub-lines and delete the existing sub-line.
1717:
1718: CREATE_SLINE_ORG_CHANGE(X_PAYROLL_LINE_ID => l_line_id,
1719: X_ASSIGNMENT_ID => l_assignment_id,

Line 1729: -- Looks into per_assignments_f for Job change during the pay period.

1725: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1726: end if;
1727:
1728:
1729: -- Looks into per_assignments_f for Job change during the pay period.
1730: -- If found split the sub-line into two sub-lines and delete the existing sub-line.
1731:
1732:
1733: CREATE_SLINE_JOB_CHANGE(X_PAYROLL_LINE_ID => l_line_id,

Line 1744: -- Looks into per_assignments_f for Position change during the pay period.

1740: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1741: end if;
1742:
1743:
1744: -- Looks into per_assignments_f for Position change during the pay period.
1745: -- If found split the sub-line into two sub-lines and delete the existing sub-line.
1746:
1747: CREATE_SLINE_POSITION_CHANGE(X_PAYROLL_LINE_ID => l_line_id,
1748: X_ASSIGNMENT_ID => l_assignment_id,

Line 1787: -- else look for the fte change in per_assignments_f.

1783:
1784:
1785: -- Get profile value of profile 'PSP_FTE_OPTIONS'
1786: -- If the value is 'Budget_Values' don't do anything
1787: -- else look for the fte change in per_assignments_f.
1788: -- If found split the sub-line into two sub-lines and delete the existing sub-line.
1789: /* Commented for Bug 4055483
1790:
1791: CREATE_SLINE_FTE_CHANGE(X_PAYROLL_LINE_ID => l_line_id,

Line 2170: FROM per_assignments_f

2166: x_return_status OUT NOCOPY VARCHAR2) IS
2167:
2168: /* CURSOR get_asg_end_date_csr IS
2169: SELECT effective_end_date
2170: FROM per_assignments_f
2171: WHERE assignment_id = x_assignment_id and
2172: effective_end_date = (select max(effective_end_date) from per_assignments_f
2173: where effective_end_date between g_start_date and
2174: g_end_date);

Line 2172: effective_end_date = (select max(effective_end_date) from per_assignments_f

2168: /* CURSOR get_asg_end_date_csr IS
2169: SELECT effective_end_date
2170: FROM per_assignments_f
2171: WHERE assignment_id = x_assignment_id and
2172: effective_end_date = (select max(effective_end_date) from per_assignments_f
2173: where effective_end_date between g_start_date and
2174: g_end_date);
2175: */
2176: CURSOR get_asg_end_date_csr IS

Line 2178: FROM per_assignments_f

2174: g_end_date);
2175: */
2176: CURSOR get_asg_end_date_csr IS
2177: SELECT max(effective_end_date)
2178: FROM per_assignments_f
2179: WHERE assignment_id = x_assignment_id
2180: -- Introduced the following condition for bug fix 2439207
2181: AND assignment_type = 'E';
2182:

Line 2223: FROM per_assignments_f

2219: x_return_status OUT NOCOPY VARCHAR2) IS
2220:
2221: /* CURSOR get_asg_end_date_csr IS
2222: SELECT effective_end_date
2223: FROM per_assignments_f
2224: WHERE assignment_id = x_assignment_id and
2225: effective_end_date = (select max(effective_end_date) from per_assignments_f
2226: where effective_end_date between g_start_date and
2227: g_end_date);

Line 2225: effective_end_date = (select max(effective_end_date) from per_assignments_f

2221: /* CURSOR get_asg_end_date_csr IS
2222: SELECT effective_end_date
2223: FROM per_assignments_f
2224: WHERE assignment_id = x_assignment_id and
2225: effective_end_date = (select max(effective_end_date) from per_assignments_f
2226: where effective_end_date between g_start_date and
2227: g_end_date);
2228:
2229:

Line 2242: FROM per_assignments_f

2238: -- that cusor had a check effective_start_date between g_Start_date and
2239: ----- g_end_date, that was causing the problem
2240: CURSOR get_asg_begin_date_csr IS
2241: SELECT min(effective_start_date)
2242: FROM per_assignments_f
2243: WHERE assignment_id = x_assignment_id
2244: AND payroll_id = l_payroll_id -- 3922347
2245: -- Introduced the following condition for bug fix 2439207
2246: AND assignment_type = 'E';

Line 2320: FROM per_assignments_f

2316: x_return_status OUT NOCOPY VARCHAR2) IS
2317:
2318: CURSOR get_asg_end_date_csr IS
2319: SELECT effective_end_date
2320: FROM per_assignments_f
2321: WHERE assignment_id = x_assignment_id and
2322: effective_end_date = (select max(effective_end_date) from per_assignments_f
2323: where effective_end_date between g_start_date and
2324: g_end_date);

Line 2322: effective_end_date = (select max(effective_end_date) from per_assignments_f

2318: CURSOR get_asg_end_date_csr IS
2319: SELECT effective_end_date
2320: FROM per_assignments_f
2321: WHERE assignment_id = x_assignment_id and
2322: effective_end_date = (select max(effective_end_date) from per_assignments_f
2323: where effective_end_date between g_start_date and
2324: g_end_date);
2325:
2326:

Line 2374: FROM per_assignments_f

2370: x_return_status OUT NOCOPY VARCHAR2) IS
2371:
2372: CURSOR get_asg_status_csr IS
2373: SELECT effective_start_date, effective_end_date
2374: FROM per_assignments_f
2375: WHERE assignment_id = x_assignment_id and
2376: (g_start_date between effective_start_date and effective_end_date or
2377: g_end_date between effective_start_date and effective_end_date or
2378: (g_start_date <= effective_start_date and g_end_date >= effective_end_date )) and

Line 3422: FROM per_assignments_f

3418: x_return_status OUT NOCOPY VARCHAR2) IS
3419:
3420: CURSOR get_asg_begin_date_csr IS
3421: SELECT effective_start_date
3422: FROM per_assignments_f
3423: WHERE assignment_id = x_assignment_id and
3424: effective_start_date between (trunc(g_start_date)+1) and g_end_date and
3425: effective_start_date = (select min(effective_start_date)
3426: from per_assignments_f

Line 3426: from per_assignments_f

3422: FROM per_assignments_f
3423: WHERE assignment_id = x_assignment_id and
3424: effective_start_date between (trunc(g_start_date)+1) and g_end_date and
3425: effective_start_date = (select min(effective_start_date)
3426: from per_assignments_f
3427: where assignment_id = x_assignment_id
3428: AND assignment_type ='E' ); --Added for bug 2624259.
3429:
3430: l_start_date date;

Line 3434: FROM per_assignments_f

3430: l_start_date date;
3431:
3432: CURSOR get_asg_end_date_csr IS
3433: SELECT effective_end_date
3434: FROM per_assignments_f
3435: WHERE assignment_id = x_assignment_id and
3436: effective_end_date between g_start_date and (trunc(g_end_date) - 1) and
3437: effective_end_date = (select max(effective_end_date)
3438: from per_assignments_f

Line 3438: from per_assignments_f

3434: FROM per_assignments_f
3435: WHERE assignment_id = x_assignment_id and
3436: effective_end_date between g_start_date and (trunc(g_end_date) - 1) and
3437: effective_end_date = (select max(effective_end_date)
3438: from per_assignments_f
3439: where assignment_id = x_assignment_id);
3440: l_end_date date;
3441:
3442: CURSOR get_sublines_csr IS

Line 3510: FROM per_assignments_f

3506: x_balance_amount IN NUMBER,
3507: x_return_status OUT NOCOPY VARCHAR2) IS
3508: CURSOR get_asg_status_csr IS
3509: SELECT effective_start_date, effective_end_date
3510: FROM per_assignments_f
3511: WHERE assignment_id = x_assignment_id and
3512: (g_start_date between effective_start_date and effective_end_date or
3513: g_end_date between effective_start_date and effective_end_date or
3514: (g_start_date <= effective_start_date and g_end_date >= effective_end_date )) and

Line 4550: FROM per_assignments_f

4546: X_BALANCE_AMOUNT IN NUMBER,
4547: X_RETURN_STATUS OUT NOCOPY VARCHAR2) IS
4548: CURSOR get_old_org_csr IS
4549: SELECT effective_start_date, organization_id
4550: FROM per_assignments_f
4551: WHERE assignment_id = x_assignment_id and
4552: effective_start_date < g_start_date and
4553: effective_start_date = (select max(effective_start_date) from per_assignments_f
4554: where assignment_id = x_assignment_id

Line 4553: effective_start_date = (select max(effective_start_date) from per_assignments_f

4549: SELECT effective_start_date, organization_id
4550: FROM per_assignments_f
4551: WHERE assignment_id = x_assignment_id and
4552: effective_start_date < g_start_date and
4553: effective_start_date = (select max(effective_start_date) from per_assignments_f
4554: where assignment_id = x_assignment_id
4555: AND assignment_type ='E' --Added for bug 2624259.
4556: AND effective_start_date < g_start_date);
4557:

Line 4563: FROM per_assignments_f

4559: l_old_org_id number(9);
4560:
4561: CURSOR get_assg_csr IS
4562: SELECT effective_start_date, effective_end_date, organization_id
4563: FROM per_assignments_f
4564: WHERE assignment_id = x_assignment_id
4565: AND assignment_type ='E' --Added for bug 2624259.
4566: AND
4567: (g_start_date between effective_start_date and effective_end_date or

Line 5143: FROM per_assignments_f

5139: X_BALANCE_AMOUNT IN NUMBER,
5140: X_RETURN_STATUS OUT NOCOPY VARCHAR2) IS
5141: CURSOR get_old_job_csr IS
5142: SELECT effective_start_date, job_id
5143: FROM per_assignments_f
5144: WHERE assignment_id = x_assignment_id and
5145: effective_start_date < g_start_date and
5146: effective_start_date = (select max(effective_start_date) from per_assignments_f
5147: where assignment_id = x_assignment_id

Line 5146: effective_start_date = (select max(effective_start_date) from per_assignments_f

5142: SELECT effective_start_date, job_id
5143: FROM per_assignments_f
5144: WHERE assignment_id = x_assignment_id and
5145: effective_start_date < g_start_date and
5146: effective_start_date = (select max(effective_start_date) from per_assignments_f
5147: where assignment_id = x_assignment_id
5148: AND assignment_type ='E' --Added for bug 2624259.
5149: AND effective_start_date < g_start_date);
5150:

Line 5156: FROM per_assignments_f

5152: l_old_job_id number(9);
5153:
5154: CURSOR get_assg_csr IS
5155: SELECT effective_start_date, effective_end_date, job_id
5156: FROM per_assignments_f
5157: WHERE assignment_id = x_assignment_id
5158: AND assignment_type ='E' --Added for bug 2624259.
5159: AND
5160: (g_start_date between effective_start_date and effective_end_date or

Line 5733: FROM per_assignments_f

5729: X_BALANCE_AMOUNT IN NUMBER,
5730: X_RETURN_STATUS OUT NOCOPY VARCHAR2) IS
5731: CURSOR get_old_position_csr IS
5732: SELECT effective_start_date, position_id
5733: FROM per_assignments_f
5734: WHERE assignment_id = x_assignment_id and
5735: effective_start_date < g_start_date and
5736: effective_start_date = (select max(effective_start_date) from per_assignments_f
5737: where assignment_id = x_assignment_id

Line 5736: effective_start_date = (select max(effective_start_date) from per_assignments_f

5732: SELECT effective_start_date, position_id
5733: FROM per_assignments_f
5734: WHERE assignment_id = x_assignment_id and
5735: effective_start_date < g_start_date and
5736: effective_start_date = (select max(effective_start_date) from per_assignments_f
5737: where assignment_id = x_assignment_id
5738: AND assignment_type ='E' --Added for bug 2624259.
5739: AND effective_start_date < g_start_date);
5740:

Line 5746: FROM per_assignments_f

5742: l_old_position_id number(15); -- Bug 2231410 : Increased the lenght of position_id column from 9 to 15
5743:
5744: CURSOR get_assg_csr IS
5745: SELECT effective_start_date, effective_end_date, position_id
5746: FROM per_assignments_f
5747: WHERE assignment_id = x_assignment_id
5748: AND assignment_type ='E' --Added for bug 2624259.
5749: AND
5750: (g_start_date between effective_start_date and effective_end_date or

Line 6326: FROM per_assignments_f

6322: X_BALANCE_AMOUNT IN NUMBER,
6323: X_RETURN_STATUS OUT NOCOPY VARCHAR2) IS
6324: CURSOR get_old_grade_csr IS
6325: SELECT effective_start_date, grade_id
6326: FROM per_assignments_f
6327: WHERE assignment_id = x_assignment_id and
6328: effective_start_date < g_start_date and
6329: effective_start_date = (select max(effective_start_date) from per_assignments_f
6330: where assignment_id = x_assignment_id

Line 6329: effective_start_date = (select max(effective_start_date) from per_assignments_f

6325: SELECT effective_start_date, grade_id
6326: FROM per_assignments_f
6327: WHERE assignment_id = x_assignment_id and
6328: effective_start_date < g_start_date and
6329: effective_start_date = (select max(effective_start_date) from per_assignments_f
6330: where assignment_id = x_assignment_id
6331: AND assignment_type ='E' --Added for bug 2624259.
6332: AND effective_start_date < g_start_date);
6333:

Line 6339: FROM per_assignments_f

6335: l_old_grade_id number(9);
6336:
6337: CURSOR get_assg_csr IS
6338: SELECT effective_start_date, effective_end_date, grade_id
6339: FROM per_assignments_f
6340: WHERE assignment_id = x_assignment_id
6341: AND assignment_type ='E' --Added for bug 2624259.
6342: AND
6343: (g_start_date between effective_start_date and effective_end_date or

Line 6921: FROM per_assignments_f

6917: X_BALANCE_AMOUNT IN NUMBER,
6918: X_RETURN_STATUS OUT NOCOPY VARCHAR2) IS
6919: CURSOR get_old_ppgroup_csr IS
6920: SELECT effective_start_date, people_group_id
6921: FROM per_assignments_f
6922: WHERE assignment_id = x_assignment_id and
6923: effective_start_date < g_start_date and
6924: effective_start_date = (select max(effective_start_date) from per_assignments_f
6925: where assignment_id = x_assignment_id

Line 6924: effective_start_date = (select max(effective_start_date) from per_assignments_f

6920: SELECT effective_start_date, people_group_id
6921: FROM per_assignments_f
6922: WHERE assignment_id = x_assignment_id and
6923: effective_start_date < g_start_date and
6924: effective_start_date = (select max(effective_start_date) from per_assignments_f
6925: where assignment_id = x_assignment_id
6926: AND assignment_type ='E' --Added for bug 2624259.
6927: AND effective_start_date < g_start_date);
6928:

Line 6934: FROM per_assignments_f

6930: l_old_ppgroup_id number(9);
6931:
6932: CURSOR get_assg_csr IS
6933: SELECT effective_start_date, effective_end_date, people_group_id
6934: FROM per_assignments_f
6935: WHERE assignment_id = x_assignment_id
6936: AND assignment_type ='E' --Added for bug 2624259.
6937: AND
6938: (g_start_date between effective_start_date and effective_end_date or

Line 7567: dbms_sql.parse(l_cur_handle,'SELECT ' || l_fte_value || ' FROM per_assignments_f WHERE assignment_id = ' ||

7563: ----dbms_output.PUT_LINE('Crossed Second if of FTE Change...' || l_fte_value);
7564: l_cur_handle := dbms_sql.open_cursor;
7565:
7566: --Added assignment_type ='E' check for bug 2624259.
7567: dbms_sql.parse(l_cur_handle,'SELECT ' || l_fte_value || ' FROM per_assignments_f WHERE assignment_id = ' ||
7568: to_char(x_assignment_id) || ' and effective_start_date = (select max(effective_start_date)' ||
7569: ' from per_assignments_f where assignment_id = ' || to_char(x_assignment_id) ||
7570: ' AND assignment_type = '||''''||'E'||'''' ||
7571: ' and effective_start_date < (select min(effective_start_date) from per_assignments_f ' ||

Line 7569: ' from per_assignments_f where assignment_id = ' || to_char(x_assignment_id) ||

7565:
7566: --Added assignment_type ='E' check for bug 2624259.
7567: dbms_sql.parse(l_cur_handle,'SELECT ' || l_fte_value || ' FROM per_assignments_f WHERE assignment_id = ' ||
7568: to_char(x_assignment_id) || ' and effective_start_date = (select max(effective_start_date)' ||
7569: ' from per_assignments_f where assignment_id = ' || to_char(x_assignment_id) ||
7570: ' AND assignment_type = '||''''||'E'||'''' ||
7571: ' and effective_start_date < (select min(effective_start_date) from per_assignments_f ' ||
7572: ' where assignment_id = ' || to_char(x_assignment_id) ||
7573: ' AND assignment_type = '||''''||'E'||'''' ||

Line 7571: ' and effective_start_date < (select min(effective_start_date) from per_assignments_f ' ||

7567: dbms_sql.parse(l_cur_handle,'SELECT ' || l_fte_value || ' FROM per_assignments_f WHERE assignment_id = ' ||
7568: to_char(x_assignment_id) || ' and effective_start_date = (select max(effective_start_date)' ||
7569: ' from per_assignments_f where assignment_id = ' || to_char(x_assignment_id) ||
7570: ' AND assignment_type = '||''''||'E'||'''' ||
7571: ' and effective_start_date < (select min(effective_start_date) from per_assignments_f ' ||
7572: ' where assignment_id = ' || to_char(x_assignment_id) ||
7573: ' AND assignment_type = '||''''||'E'||'''' ||
7574: ' and (( :g_start_date ' ||
7575: ' between effective_start_date and effective_end_date) or ( :g_end_date between ' ||

Line 7611: ' FROM per_assignments_f WHERE assignment_id = ' || to_char(x_assignment_id) ||

7607: l_cur_handle := dbms_sql.open_cursor;
7608:
7609: --Added assignment_type ='E' for bug 2624259.
7610: dbms_sql.parse(l_cur_handle,'SELECT effective_start_date, effective_end_date, ' || l_fte_value ||
7611: ' FROM per_assignments_f WHERE assignment_id = ' || to_char(x_assignment_id) ||
7612: ' AND assignment_type = '||''''||'E'||'''' ||
7613: ' and (:g_start_date between effective_start_date and effective_end_date or ' ||
7614: ':g_end_date between effective_start_date and effective_end_date or (:g_start_date ' ||
7615: ' <= effective_start_date and :g_end_date >= effective_end_date )) order by ' ||

Line 8805: FROM per_assignments_f paf,

8801: l_effective_start_date DATE;
8802:
8803: CURSOR non_active_asg_csr IS
8804: SELECT count(*)
8805: FROM per_assignments_f paf,
8806: per_assignment_status_types past
8807: WHERE assignment_id = x_assignment_id
8808: AND g_start_date <= effective_end_date
8809: AND g_end_date >= effective_start_date

Line 8815: FROM per_assignments_f paf

8811: AND past.per_system_status NOT IN ('ACTIVE_ASSIGN');
8812:
8813: CURSOR hire_zero_days_csr IS
8814: SELECT min(paf.effective_start_date)
8815: FROM per_assignments_f paf
8816: WHERE paf.assignment_id = x_assignment_id
8817: AND assignment_type = 'E' --Added for bug 2624259.
8818: AND g_start_date <= paf.effective_end_date
8819: AND g_end_date >= paf.effective_start_date

Line 8874: select assignment_number into l_assignment_number from per_assignments_f where assignment_id =x_assignment_id

8870:
8871: EXCEPTION
8872: WHEN OTHERS then
8873: ------dbms_output.put_line('Check_zero_work_days.....'||x_assignment_id||' '||x_costed_value);
8874: select assignment_number into l_assignment_number from per_assignments_f where assignment_id =x_assignment_id
8875: and effective_start_date=(select max(effective_start_date) from per_assignments_f where
8876: assignment_id=x_assignment_id);
8877: fnd_message.set_name('PSP','PSP_ZERO_WORK_DAYS');
8878: fnd_message.set_token('ASSIGNMENT_NO',l_assignment_number);

Line 8875: and effective_start_date=(select max(effective_start_date) from per_assignments_f where

8871: EXCEPTION
8872: WHEN OTHERS then
8873: ------dbms_output.put_line('Check_zero_work_days.....'||x_assignment_id||' '||x_costed_value);
8874: select assignment_number into l_assignment_number from per_assignments_f where assignment_id =x_assignment_id
8875: and effective_start_date=(select max(effective_start_date) from per_assignments_f where
8876: assignment_id=x_assignment_id);
8877: fnd_message.set_name('PSP','PSP_ZERO_WORK_DAYS');
8878: fnd_message.set_token('ASSIGNMENT_NO',l_assignment_number);
8879: fnd_message.set_token('LINE_AMT',x_costed_value );