DBA Data[Home] [Help]

APPS.PQH_GL_POSTING dependencies on PER_ALL_ASSIGNMENTS_F

Line 4502: From per_all_assignments_f

4498: Select
4499: assignment_id,
4500: effective_start_date,
4501: effective_end_date
4502: From per_all_assignments_f
4503: Where position_id=l_entity_id and
4504: (
4505: (effective_start_date <=start_date AND effective_end_date >start_date)
4506: OR

Line 4516: From per_all_assignments_f

4512: Select
4513: assignment_id,
4514: effective_start_date,
4515: effective_end_date
4516: From per_all_assignments_f
4517: Where organization_id=l_entity_id and
4518: (
4519: (effective_start_date <=start_date AND effective_end_date >start_date)
4520: OR

Line 4530: From per_all_assignments_f

4526: Select
4527: assignment_id,
4528: effective_start_date,
4529: effective_end_date
4530: From per_all_assignments_f
4531: Where grade_id=l_entity_id and
4532: (
4533: (effective_start_date <=start_date AND effective_end_date >start_date)
4534: OR

Line 4544: From per_all_assignments_f

4540: Select
4541: assignment_id,
4542: effective_start_date,
4543: effective_end_date
4544: From per_all_assignments_f
4545: Where job_id=l_entity_id and
4546: (
4547: (effective_start_date <=start_date AND effective_end_date >start_date)
4548: OR