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

Line 150: FROM per_all_assignments_f asg, per_cagr_entitlement_results res

146: ,res.FROM_STEP_ID
147: ,res.TO_STEP_ID
148: ,res.CHOSEN_FLAG
149: ,res.BENEFICIAL_FLAG
150: FROM per_all_assignments_f asg, per_cagr_entitlement_results res
151: WHERE asg.assignment_id = res.assignment_id
152: AND asg.primary_flag = 'Y'
153: AND p_process_date between asg.effective_start_date and asg.effective_end_date
154: AND res.cagr_entitlement_item_id = p_entitlement_item_id

Line 215: from per_collective_agreements cagr, per_all_assignments_f asg

211: SELECT item.opt_id
212: FROM per_cagr_entitlement_items item
213: WHERE item.cagr_entitlement_item_id = p_params.entitlement_item_id
214: AND exists (select 'x'
215: from per_collective_agreements cagr, per_all_assignments_f asg
216: where cagr.status = 'A'
217: and p_params.effective_date >= cagr.start_date
218: and cagr.collective_agreement_id in (select distinct(pce.collective_agreement_id)
219: from per_cagr_entitlements pce, per_cagr_entitlement_lines_f pcel

Line 245: FROM per_collective_agreements cagr, per_all_assignments_f asg

241:
242:
243: CURSOR csr_BE_assignments_to_process IS
244: SELECT cagr.collective_agreement_id, asg.assignment_id, asg.grade_id, asg.person_id
245: FROM per_collective_agreements cagr, per_all_assignments_f asg
246: WHERE cagr.status = 'A'
247: AND p_params.effective_date >= cagr.start_date
248: AND cagr.collective_agreement_id in (select distinct(pce.collective_agreement_id)
249: from per_cagr_entitlements pce

Line 274: from per_all_assignments_f asg

270: AND p_params.effective_date BETWEEN cagr.START_DATE
271: AND nvl(cagr.END_DATE, hr_general.end_of_time)
272: AND cagr.STATUS = 'A'
273: AND exists (select 'x'
274: from per_all_assignments_f asg
275: where p_params.effective_date BETWEEN asg.effective_start_date
276: AND asg.effective_end_date
277: and asg.COLLECTIVE_AGREEMENT_ID = p_params.COLLECTIVE_AGREEMENT_ID
278: and asg.PRIMARY_FLAG = 'Y')

Line 293: FROM per_all_assignments_f asg

289:
290:
291: CURSOR csr_assignments_to_process IS
292: SELECT assignment_id, grade_id, person_id
293: FROM per_all_assignments_f asg
294: WHERE collective_agreement_id = p_params.collective_agreement_id
295: AND p_params.effective_date BETWEEN asg.effective_start_date
296: AND asg.effective_end_date
297: AND asg.PRIMARY_FLAG = 'Y';

Line 363: FROM per_all_assignments_f asg, per_collective_agreements cagr

359: CURSOR csr_SA_drive_benmngle IS
360: SELECT asg.COLLECTIVE_AGREEMENT_ID,
361: asg.PERSON_ID,
362: cagr.PL_ID
363: FROM per_all_assignments_f asg, per_collective_agreements cagr
364: WHERE asg.ASSIGNMENT_ID = p_params.assignment_id
365: AND p_params.effective_date BETWEEN asg.effective_start_date
366: AND asg.effective_end_date
367: AND asg.PRIMARY_FLAG = 'Y'

Line 422: FROM per_all_assignments_f asg,

418: pcel.FROM_STEP_ID,
419: pcel.TO_STEP_ID,
420: pcel.OIPL_ID, -- BEN comp obj
421: pcel.ELIGY_PRFL_ID -- BEN elig profile
422: FROM per_all_assignments_f asg,
423: per_collective_agreements cagr,
424: per_cagr_entitlements pce,
425: per_cagr_entitlement_items pcei,
426: per_cagr_entitlement_lines_f pcel

Line 456: FROM per_all_assignments_f asg, per_collective_agreements cagr

452: CURSOR csr_SE_drive_benmngle IS
453: SELECT asg.COLLECTIVE_AGREEMENT_ID,
454: asg.PERSON_ID,
455: cagr.PL_ID
456: FROM per_all_assignments_f asg, per_collective_agreements cagr
457: WHERE asg.assignment_id = p_params.assignment_id
458: AND p_params.effective_date BETWEEN asg.effective_start_date
459: AND asg.effective_end_date
460: AND asg.PRIMARY_FLAG = 'Y'

Line 515: FROM per_all_assignments_f asg,

511: pcel.FROM_STEP_ID,
512: pcel.TO_STEP_ID,
513: pcel.OIPL_ID, -- BEN comp obj
514: pcel.ELIGY_PRFL_ID -- BEN elig profile
515: FROM per_all_assignments_f asg,
516: per_collective_agreements cagr,
517: per_cagr_entitlements pce,
518: per_cagr_entitlement_items pcei,
519: per_cagr_entitlement_lines_f pcel

Line 545: FROM per_all_assignments_f asg

541:
542: -- SE mode check cursor
543: CURSOR csr_primary_asg is
544: SELECT 'X'
545: FROM per_all_assignments_f asg
546: WHERE asg.assignment_id = p_params.assignment_id
547: AND p_params.effective_date BETWEEN asg.effective_start_date AND asg.effective_end_date
548: AND asg.primary_flag = 'Y';
549:

Line 2107: AND EXISTS (select 'X' from per_all_assignments_f asg

2103: FROM per_cagr_retained_rights pcrr
2104: WHERE pcrr.assignment_id = p_params.assignment_id
2105: AND p_params.effective_date BETWEEN pcrr.START_DATE
2106: AND nvl(pcrr.END_DATE,hr_general.end_of_time)
2107: AND EXISTS (select 'X' from per_all_assignments_f asg
2108: where asg.assignment_id = p_params.assignment_id
2109: and p_params.effective_date BETWEEN asg.effective_start_date
2110: AND asg.effective_end_date
2111: and asg.PRIMARY_FLAG = 'Y')