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.PA_RESOURCE_UTILS dependencies on PER_ALL_ASSIGNMENTS_F

Line 1339: v_orgid per_all_assignments_f.organization_id%TYPE;

1335: X_return_Status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
1336: X_error_message_code OUT NOCOPY VARCHAR2) is --File.Sql.39 bug 4440895
1337:
1338: v_validated VARCHAR2(1);
1339: v_orgid per_all_assignments_f.organization_id%TYPE;
1340: v_roleid fnd_grants.menu_id%TYPE;
1341: v_objid fnd_grants.object_id%TYPE;
1342: v_resid fnd_grants.grantee_key%TYPE;
1343: v_objname VARCHAR2(25) := 'ORGANIZATION';

Line 1352: orgid per_all_assignments_f.organization_id%TYPE,

1348: missing_role EXCEPTION;
1349: j NUMBER;
1350:
1351: cursor analystid(objid fnd_grants.object_id%TYPE,
1352: orgid per_all_assignments_f.organization_id%TYPE,
1353: roleid fnd_grants.menu_id%TYPE ) is
1354: SELECT distinct per.person_id
1355: FROM fnd_grants fg, wf_roles wfr, per_all_people_f per
1356: WHERE fg.object_id = objid

Line 1400: FROM per_all_assignments_f -- Bug 4684198 - use base table not view

1396: -- it may raise no data found exception if person is not on
1397: -- current assignment
1398: SELECT organization_id
1399: INTO v_orgid
1400: FROM per_all_assignments_f -- Bug 4684198 - use base table not view
1401: WHERE person_id = P_PersonId
1402: AND trunc(sysdate) BETWEEN effective_start_date
1403: AND effective_end_date
1404: -- Bug 4684198 - remove nvl on effective_end_date - col is not null

Line 1624: FROM per_all_assignments_f assn,per_all_people_f pep

1620: --Modified code for future dated person
1621: --Manager check is still as of sysdate
1622: SELECT assn.supervisor_id,pep.full_name
1623: INTO x_ManagerId,x_ManagerName
1624: FROM per_all_assignments_f assn,per_all_people_f pep
1625: WHERE assn.person_id = P_personId
1626: AND pep.person_id = assn.supervisor_id
1627: AND trunc(p_start_date) BETWEEN assn.effective_start_date /*Bug 8817301 */
1628: AND assn.effective_end_date

Line 1651: FROM per_all_assignments_f assn,

1647: /*bug 3737529 - Code addition starts*/
1648: BEGIN
1649: SELECT assn.supervisor_id,pep.full_name
1650: INTO x_ManagerId,x_ManagerName
1651: FROM per_all_assignments_f assn,
1652: per_all_people_f pep
1653: WHERE assn.person_id = P_personId
1654: AND pep.person_id = assn.supervisor_id
1655: AND trunc(p_start_date) BETWEEN assn.effective_start_date /*Bug 8817301 */

Line 1679: FROM per_all_assignments_f assn,per_all_people_f pep

1675:
1676: BEGIN
1677: SELECT assn.supervisor_id,pep.full_name
1678: INTO x_ManagerId,x_ManagerName
1679: FROM per_all_assignments_f assn,per_all_people_f pep
1680: WHERE assn.person_id = P_personId
1681: AND pep.person_id = assn.supervisor_id
1682: AND trunc(p_start_date) BETWEEN assn.effective_start_date /*Bug 8817301 */
1683: AND assn.effective_end_date

Line 1734: FROM per_all_assignments_f

1730: -- where assignment type is primary type.
1731: -- may raise exception if the person is not on current assnment
1732: SELECT organization_id
1733: INTO x_orgid
1734: FROM per_all_assignments_f
1735: WHERE person_id = P_personId
1736: AND trunc(p_start_date) BETWEEN effective_start_date --bug 9403051
1737: AND effective_end_date
1738: AND primary_flag = 'Y'

Line 1902: v_orgid per_all_assignments_f.organization_id%TYPE;

1898: ) is
1899:
1900: v_personId NUMBER;
1901: v_numrows NUMBER;
1902: v_orgid per_all_assignments_f.organization_id%TYPE;
1903: v_objid fnd_grants.object_id%TYPE;
1904: --v_resid fnd_grants.grantee_key%TYPE;
1905: v_objname VARCHAR2(25) := 'ORGANIZATION';
1906: v_primrolename VARCHAR2(30) := 'PA_PRM_RES_PRMRY_CONTACT';

Line 3869: from per_all_assignments_f asgn,

3865:
3866: cursor get_active_assignment
3867: is
3868: select asgn.assignment_id
3869: from per_all_assignments_f asgn,
3870: per_assignment_status_types status,
3871: (select person_id, actual_termination_date
3872: from per_periods_of_service
3873: union all

Line 3889: from per_all_assignments_f asgn,

3885:
3886: cursor get_primary_assignment
3887: is
3888: select asgn.assignment_id
3889: from per_all_assignments_f asgn,
3890: (select person_id, actual_termination_date
3891: from per_periods_of_service
3892: union all
3893: select person_id, actual_termination_date

Line 3907: from per_all_assignments_f asgn,

3903:
3904: cursor get_job_on_assignment
3905: is
3906: select asgn.job_id
3907: from per_all_assignments_f asgn,
3908: (select person_id, actual_termination_date
3909: from per_periods_of_service
3910: union all
3911: select person_id, actual_termination_date

Line 4616: FROM per_all_assignments_f asg,

4612: IF p_person_id IS NOT NULL THEN
4613:
4614: SELECT NVL(pp.projected_termination_date, asg.projected_assignment_end) -- Bug#14594489
4615: INTO l_term_date
4616: FROM per_all_assignments_f asg,
4617: per_periods_of_placement pp
4618: WHERE asg.person_id = p_person_id
4619: AND pp.person_id = p_person_id
4620: AND asg.primary_flag = 'Y'