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 235: PER_ASSIGNMENTS_F b

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

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

1137: -- CREATE_WORKING_CALENDAR;
1138: create_working_calendar(l_assignment_id);
1139: g_no_of_person_work_days := g_no_of_work_days;
1140:
1141: -- This procedure looks into per_assignments_f for assignment
1142: -- end date. If the assignment end date falls in to the payroll period,
1143: -- it updates the array rows with 'N' for the rows after the assignment end date.
1144:
1145: hr_utility.trace(' UPDATE_WCAL_ASG_END_DATE');

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

1157: l_error_api_name := 'UPDATE_WCAL_ASG_BEGIN_DATE : ';
1158: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1159: end if;
1160:
1161: -- This procedure looks into per_assignments_f for assignment
1162: -- status. If the assignment status is 'Suspend' or 'Terminate' for any of the days
1163: -- in the payroll period, it updates the working calendar array with 'N' for those days.
1164:
1165: hr_utility.trace(' UPDATE_WCAL_ASG_STATUS');

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

1620: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1621: end if;
1622:
1623:
1624: -- Looks in to per_assignments_f for assignment statuses either
1625: -- 'Suspend' or 'Terminate' during the pay period.
1626: -- If found then split the sub-line in to two sub-lines and
1627: -- delete the existing sub-line.
1628:

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

1649: ----dbms_output.PUT_LINE('...CREATE_SLINE_EMP_END_DATE :');
1650: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1651: end if;
1652:
1653: -- Looks into per_assignments_f for Organization change during the pay period.
1654: -- If found split the sub-line into two sub-lines and delete the existing sub-line.
1655:
1656: CREATE_SLINE_ORG_CHANGE(X_PAYROLL_LINE_ID => l_line_id,
1657: X_ASSIGNMENT_ID => l_assignment_id,

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

1663: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1664: end if;
1665:
1666:
1667: -- Looks into per_assignments_f for Job change during the pay period.
1668: -- If found split the sub-line into two sub-lines and delete the existing sub-line.
1669:
1670:
1671: CREATE_SLINE_JOB_CHANGE(X_PAYROLL_LINE_ID => l_line_id,

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

1678: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1679: end if;
1680:
1681:
1682: -- Looks into per_assignments_f for Position change during the pay period.
1683: -- If found split the sub-line into two sub-lines and delete the existing sub-line.
1684:
1685: CREATE_SLINE_POSITION_CHANGE(X_PAYROLL_LINE_ID => l_line_id,
1686: X_ASSIGNMENT_ID => l_assignment_id,

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

1721:
1722:
1723: -- Get profile value of profile 'PSP_FTE_OPTIONS'
1724: -- If the value is 'Budget_Values' don't do anything
1725: -- else look for the fte change in per_assignments_f.
1726: -- If found split the sub-line into two sub-lines and delete the existing sub-line.
1727: /* Commented for Bug 4055483
1728:
1729: CREATE_SLINE_FTE_CHANGE(X_PAYROLL_LINE_ID => l_line_id,

Line 2096: FROM per_assignments_f

2092: x_return_status OUT NOCOPY VARCHAR2) IS
2093:
2094: /* CURSOR get_asg_end_date_csr IS
2095: SELECT effective_end_date
2096: FROM per_assignments_f
2097: WHERE assignment_id = x_assignment_id and
2098: effective_end_date = (select max(effective_end_date) from per_assignments_f
2099: where effective_end_date between g_start_date and
2100: g_end_date);

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

2094: /* CURSOR get_asg_end_date_csr IS
2095: SELECT effective_end_date
2096: FROM per_assignments_f
2097: WHERE assignment_id = x_assignment_id and
2098: effective_end_date = (select max(effective_end_date) from per_assignments_f
2099: where effective_end_date between g_start_date and
2100: g_end_date);
2101: */
2102: CURSOR get_asg_end_date_csr IS

Line 2104: FROM per_assignments_f

2100: g_end_date);
2101: */
2102: CURSOR get_asg_end_date_csr IS
2103: SELECT max(effective_end_date)
2104: FROM per_assignments_f
2105: WHERE assignment_id = x_assignment_id
2106: -- Introduced the following condition for bug fix 2439207
2107: AND assignment_type = 'E';
2108:

Line 2149: FROM per_assignments_f

2145: x_return_status OUT NOCOPY VARCHAR2) IS
2146:
2147: /* CURSOR get_asg_end_date_csr IS
2148: SELECT effective_end_date
2149: FROM per_assignments_f
2150: WHERE assignment_id = x_assignment_id and
2151: effective_end_date = (select max(effective_end_date) from per_assignments_f
2152: where effective_end_date between g_start_date and
2153: g_end_date);

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

2147: /* CURSOR get_asg_end_date_csr IS
2148: SELECT effective_end_date
2149: FROM per_assignments_f
2150: WHERE assignment_id = x_assignment_id and
2151: effective_end_date = (select max(effective_end_date) from per_assignments_f
2152: where effective_end_date between g_start_date and
2153: g_end_date);
2154:
2155:

Line 2168: FROM per_assignments_f

2164: -- that cusor had a check effective_start_date between g_Start_date and
2165: ----- g_end_date, that was causing the problem
2166: CURSOR get_asg_begin_date_csr IS
2167: SELECT min(effective_start_date)
2168: FROM per_assignments_f
2169: WHERE assignment_id = x_assignment_id
2170: AND payroll_id = l_payroll_id -- 3922347
2171: -- Introduced the following condition for bug fix 2439207
2172: AND assignment_type = 'E';

Line 2246: FROM per_assignments_f

2242: x_return_status OUT NOCOPY VARCHAR2) IS
2243:
2244: CURSOR get_asg_end_date_csr IS
2245: SELECT effective_end_date
2246: FROM per_assignments_f
2247: WHERE assignment_id = x_assignment_id and
2248: effective_end_date = (select max(effective_end_date) from per_assignments_f
2249: where effective_end_date between g_start_date and
2250: g_end_date);

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

2244: CURSOR get_asg_end_date_csr IS
2245: SELECT effective_end_date
2246: FROM per_assignments_f
2247: WHERE assignment_id = x_assignment_id and
2248: effective_end_date = (select max(effective_end_date) from per_assignments_f
2249: where effective_end_date between g_start_date and
2250: g_end_date);
2251:
2252:

Line 2300: FROM per_assignments_f

2296: x_return_status OUT NOCOPY VARCHAR2) IS
2297:
2298: CURSOR get_asg_status_csr IS
2299: SELECT effective_start_date, effective_end_date
2300: FROM per_assignments_f
2301: WHERE assignment_id = x_assignment_id and
2302: (g_start_date between effective_start_date and effective_end_date or
2303: g_end_date between effective_start_date and effective_end_date or
2304: (g_start_date <= effective_start_date and g_end_date >= effective_end_date )) and

Line 3348: FROM per_assignments_f

3344: x_return_status OUT NOCOPY VARCHAR2) IS
3345:
3346: CURSOR get_asg_begin_date_csr IS
3347: SELECT effective_start_date
3348: FROM per_assignments_f
3349: WHERE assignment_id = x_assignment_id and
3350: effective_start_date between (trunc(g_start_date)+1) and g_end_date and
3351: effective_start_date = (select min(effective_start_date)
3352: from per_assignments_f

Line 3352: from per_assignments_f

3348: FROM per_assignments_f
3349: WHERE assignment_id = x_assignment_id and
3350: effective_start_date between (trunc(g_start_date)+1) and g_end_date and
3351: effective_start_date = (select min(effective_start_date)
3352: from per_assignments_f
3353: where assignment_id = x_assignment_id
3354: AND assignment_type ='E' ); --Added for bug 2624259.
3355:
3356: l_start_date date;

Line 3360: FROM per_assignments_f

3356: l_start_date date;
3357:
3358: CURSOR get_asg_end_date_csr IS
3359: SELECT effective_end_date
3360: FROM per_assignments_f
3361: WHERE assignment_id = x_assignment_id and
3362: effective_end_date between g_start_date and (trunc(g_end_date) - 1) and
3363: effective_end_date = (select max(effective_end_date)
3364: from per_assignments_f

Line 3364: from per_assignments_f

3360: FROM per_assignments_f
3361: WHERE assignment_id = x_assignment_id and
3362: effective_end_date between g_start_date and (trunc(g_end_date) - 1) and
3363: effective_end_date = (select max(effective_end_date)
3364: from per_assignments_f
3365: where assignment_id = x_assignment_id);
3366: l_end_date date;
3367:
3368: CURSOR get_sublines_csr IS

Line 3436: FROM per_assignments_f

3432: x_balance_amount IN NUMBER,
3433: x_return_status OUT NOCOPY VARCHAR2) IS
3434: CURSOR get_asg_status_csr IS
3435: SELECT effective_start_date, effective_end_date
3436: FROM per_assignments_f
3437: WHERE assignment_id = x_assignment_id and
3438: (g_start_date between effective_start_date and effective_end_date or
3439: g_end_date between effective_start_date and effective_end_date or
3440: (g_start_date <= effective_start_date and g_end_date >= effective_end_date )) and

Line 4476: FROM per_assignments_f

4472: X_BALANCE_AMOUNT IN NUMBER,
4473: X_RETURN_STATUS OUT NOCOPY VARCHAR2) IS
4474: CURSOR get_old_org_csr IS
4475: SELECT effective_start_date, organization_id
4476: FROM per_assignments_f
4477: WHERE assignment_id = x_assignment_id and
4478: effective_start_date < g_start_date and
4479: effective_start_date = (select max(effective_start_date) from per_assignments_f
4480: where assignment_id = x_assignment_id

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

4475: SELECT effective_start_date, organization_id
4476: FROM per_assignments_f
4477: WHERE assignment_id = x_assignment_id and
4478: effective_start_date < g_start_date and
4479: effective_start_date = (select max(effective_start_date) from per_assignments_f
4480: where assignment_id = x_assignment_id
4481: AND assignment_type ='E' --Added for bug 2624259.
4482: AND effective_start_date < g_start_date);
4483:

Line 4489: FROM per_assignments_f

4485: l_old_org_id number(9);
4486:
4487: CURSOR get_assg_csr IS
4488: SELECT effective_start_date, effective_end_date, organization_id
4489: FROM per_assignments_f
4490: WHERE assignment_id = x_assignment_id
4491: AND assignment_type ='E' --Added for bug 2624259.
4492: AND
4493: (g_start_date between effective_start_date and effective_end_date or

Line 5069: FROM per_assignments_f

5065: X_BALANCE_AMOUNT IN NUMBER,
5066: X_RETURN_STATUS OUT NOCOPY VARCHAR2) IS
5067: CURSOR get_old_job_csr IS
5068: SELECT effective_start_date, job_id
5069: FROM per_assignments_f
5070: WHERE assignment_id = x_assignment_id and
5071: effective_start_date < g_start_date and
5072: effective_start_date = (select max(effective_start_date) from per_assignments_f
5073: where assignment_id = x_assignment_id

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

5068: SELECT effective_start_date, job_id
5069: FROM per_assignments_f
5070: WHERE assignment_id = x_assignment_id and
5071: effective_start_date < g_start_date and
5072: effective_start_date = (select max(effective_start_date) from per_assignments_f
5073: where assignment_id = x_assignment_id
5074: AND assignment_type ='E' --Added for bug 2624259.
5075: AND effective_start_date < g_start_date);
5076:

Line 5082: FROM per_assignments_f

5078: l_old_job_id number(9);
5079:
5080: CURSOR get_assg_csr IS
5081: SELECT effective_start_date, effective_end_date, job_id
5082: FROM per_assignments_f
5083: WHERE assignment_id = x_assignment_id
5084: AND assignment_type ='E' --Added for bug 2624259.
5085: AND
5086: (g_start_date between effective_start_date and effective_end_date or

Line 5659: FROM per_assignments_f

5655: X_BALANCE_AMOUNT IN NUMBER,
5656: X_RETURN_STATUS OUT NOCOPY VARCHAR2) IS
5657: CURSOR get_old_position_csr IS
5658: SELECT effective_start_date, position_id
5659: FROM per_assignments_f
5660: WHERE assignment_id = x_assignment_id and
5661: effective_start_date < g_start_date and
5662: effective_start_date = (select max(effective_start_date) from per_assignments_f
5663: where assignment_id = x_assignment_id

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

5658: SELECT effective_start_date, position_id
5659: FROM per_assignments_f
5660: WHERE assignment_id = x_assignment_id and
5661: effective_start_date < g_start_date and
5662: effective_start_date = (select max(effective_start_date) from per_assignments_f
5663: where assignment_id = x_assignment_id
5664: AND assignment_type ='E' --Added for bug 2624259.
5665: AND effective_start_date < g_start_date);
5666:

Line 5672: FROM per_assignments_f

5668: l_old_position_id number(15); -- Bug 2231410 : Increased the lenght of position_id column from 9 to 15
5669:
5670: CURSOR get_assg_csr IS
5671: SELECT effective_start_date, effective_end_date, position_id
5672: FROM per_assignments_f
5673: WHERE assignment_id = x_assignment_id
5674: AND assignment_type ='E' --Added for bug 2624259.
5675: AND
5676: (g_start_date between effective_start_date and effective_end_date or

Line 6252: FROM per_assignments_f

6248: X_BALANCE_AMOUNT IN NUMBER,
6249: X_RETURN_STATUS OUT NOCOPY VARCHAR2) IS
6250: CURSOR get_old_grade_csr IS
6251: SELECT effective_start_date, grade_id
6252: FROM per_assignments_f
6253: WHERE assignment_id = x_assignment_id and
6254: effective_start_date < g_start_date and
6255: effective_start_date = (select max(effective_start_date) from per_assignments_f
6256: where assignment_id = x_assignment_id

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

6251: SELECT effective_start_date, grade_id
6252: FROM per_assignments_f
6253: WHERE assignment_id = x_assignment_id and
6254: effective_start_date < g_start_date and
6255: effective_start_date = (select max(effective_start_date) from per_assignments_f
6256: where assignment_id = x_assignment_id
6257: AND assignment_type ='E' --Added for bug 2624259.
6258: AND effective_start_date < g_start_date);
6259:

Line 6265: FROM per_assignments_f

6261: l_old_grade_id number(9);
6262:
6263: CURSOR get_assg_csr IS
6264: SELECT effective_start_date, effective_end_date, grade_id
6265: FROM per_assignments_f
6266: WHERE assignment_id = x_assignment_id
6267: AND assignment_type ='E' --Added for bug 2624259.
6268: AND
6269: (g_start_date between effective_start_date and effective_end_date or

Line 6847: FROM per_assignments_f

6843: X_BALANCE_AMOUNT IN NUMBER,
6844: X_RETURN_STATUS OUT NOCOPY VARCHAR2) IS
6845: CURSOR get_old_ppgroup_csr IS
6846: SELECT effective_start_date, people_group_id
6847: FROM per_assignments_f
6848: WHERE assignment_id = x_assignment_id and
6849: effective_start_date < g_start_date and
6850: effective_start_date = (select max(effective_start_date) from per_assignments_f
6851: where assignment_id = x_assignment_id

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

6846: SELECT effective_start_date, people_group_id
6847: FROM per_assignments_f
6848: WHERE assignment_id = x_assignment_id and
6849: effective_start_date < g_start_date and
6850: effective_start_date = (select max(effective_start_date) from per_assignments_f
6851: where assignment_id = x_assignment_id
6852: AND assignment_type ='E' --Added for bug 2624259.
6853: AND effective_start_date < g_start_date);
6854:

Line 6860: FROM per_assignments_f

6856: l_old_ppgroup_id number(9);
6857:
6858: CURSOR get_assg_csr IS
6859: SELECT effective_start_date, effective_end_date, people_group_id
6860: FROM per_assignments_f
6861: WHERE assignment_id = x_assignment_id
6862: AND assignment_type ='E' --Added for bug 2624259.
6863: AND
6864: (g_start_date between effective_start_date and effective_end_date or

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

7489: ----dbms_output.PUT_LINE('Crossed Second if of FTE Change...' || l_fte_value);
7490: l_cur_handle := dbms_sql.open_cursor;
7491:
7492: --Added assignment_type ='E' check for bug 2624259.
7493: dbms_sql.parse(l_cur_handle,'SELECT ' || l_fte_value || ' FROM per_assignments_f WHERE assignment_id = ' ||
7494: to_char(x_assignment_id) || ' and effective_start_date = (select max(effective_start_date)' ||
7495: ' from per_assignments_f where assignment_id = ' || to_char(x_assignment_id) ||
7496: ' AND assignment_type = '||''''||'E'||'''' ||
7497: ' and effective_start_date < (select min(effective_start_date) from per_assignments_f ' ||

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

7491:
7492: --Added assignment_type ='E' check for bug 2624259.
7493: dbms_sql.parse(l_cur_handle,'SELECT ' || l_fte_value || ' FROM per_assignments_f WHERE assignment_id = ' ||
7494: to_char(x_assignment_id) || ' and effective_start_date = (select max(effective_start_date)' ||
7495: ' from per_assignments_f where assignment_id = ' || to_char(x_assignment_id) ||
7496: ' AND assignment_type = '||''''||'E'||'''' ||
7497: ' and effective_start_date < (select min(effective_start_date) from per_assignments_f ' ||
7498: ' where assignment_id = ' || to_char(x_assignment_id) ||
7499: ' AND assignment_type = '||''''||'E'||'''' ||

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

7493: dbms_sql.parse(l_cur_handle,'SELECT ' || l_fte_value || ' FROM per_assignments_f WHERE assignment_id = ' ||
7494: to_char(x_assignment_id) || ' and effective_start_date = (select max(effective_start_date)' ||
7495: ' from per_assignments_f where assignment_id = ' || to_char(x_assignment_id) ||
7496: ' AND assignment_type = '||''''||'E'||'''' ||
7497: ' and effective_start_date < (select min(effective_start_date) from per_assignments_f ' ||
7498: ' where assignment_id = ' || to_char(x_assignment_id) ||
7499: ' AND assignment_type = '||''''||'E'||'''' ||
7500: ' and (( :g_start_date ' ||
7501: ' between effective_start_date and effective_end_date) or ( :g_end_date between ' ||

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

7533: l_cur_handle := dbms_sql.open_cursor;
7534:
7535: --Added assignment_type ='E' for bug 2624259.
7536: dbms_sql.parse(l_cur_handle,'SELECT effective_start_date, effective_end_date, ' || l_fte_value ||
7537: ' FROM per_assignments_f WHERE assignment_id = ' || to_char(x_assignment_id) ||
7538: ' AND assignment_type = '||''''||'E'||'''' ||
7539: ' and (:g_start_date between effective_start_date and effective_end_date or ' ||
7540: ':g_end_date between effective_start_date and effective_end_date or (:g_start_date ' ||
7541: ' <= effective_start_date and :g_end_date >= effective_end_date )) order by ' ||

Line 8731: FROM per_assignments_f paf,

8727: l_effective_start_date DATE;
8728:
8729: CURSOR non_active_asg_csr IS
8730: SELECT count(*)
8731: FROM per_assignments_f paf,
8732: per_assignment_status_types past
8733: WHERE assignment_id = x_assignment_id
8734: AND g_start_date <= effective_end_date
8735: AND g_end_date >= effective_start_date

Line 8741: FROM per_assignments_f paf

8737: AND past.per_system_status NOT IN ('ACTIVE_ASSIGN');
8738:
8739: CURSOR hire_zero_days_csr IS
8740: SELECT min(paf.effective_start_date)
8741: FROM per_assignments_f paf
8742: WHERE paf.assignment_id = x_assignment_id
8743: AND assignment_type = 'E' --Added for bug 2624259.
8744: AND g_start_date <= paf.effective_end_date
8745: AND g_end_date >= paf.effective_start_date

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

8796:
8797: EXCEPTION
8798: WHEN OTHERS then
8799: ------dbms_output.put_line('Check_zero_work_days.....'||x_assignment_id||' '||x_costed_value);
8800: select assignment_number into l_assignment_number from per_assignments_f where assignment_id =x_assignment_id
8801: and effective_start_date=(select max(effective_start_date) from per_assignments_f where
8802: assignment_id=x_assignment_id);
8803: fnd_message.set_name('PSP','PSP_ZERO_WORK_DAYS');
8804: fnd_message.set_token('ASSIGNMENT_NO',l_assignment_number);

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

8797: EXCEPTION
8798: WHEN OTHERS then
8799: ------dbms_output.put_line('Check_zero_work_days.....'||x_assignment_id||' '||x_costed_value);
8800: select assignment_number into l_assignment_number from per_assignments_f where assignment_id =x_assignment_id
8801: and effective_start_date=(select max(effective_start_date) from per_assignments_f where
8802: assignment_id=x_assignment_id);
8803: fnd_message.set_name('PSP','PSP_ZERO_WORK_DAYS');
8804: fnd_message.set_token('ASSIGNMENT_NO',l_assignment_number);
8805: fnd_message.set_token('LINE_AMT',x_costed_value );