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_PAY_PROPOSALS_POPULATE dependencies on PER_ALL_ASSIGNMENTS_F

Line 29: , PER_ALL_ASSIGNMENTS_F ASG

25: , PRV.RATE_UOM
26: FROM PER_PAY_BASES PPB
27: , PAY_GRADE_RULES_F PGR
28: , PAY_RATES_V PRV
29: , PER_ALL_ASSIGNMENTS_F ASG
30: WHERE ASG.ASSIGNMENT_ID=p_assignment_id
31: AND PPB.PAY_BASIS_ID=ASG.PAY_BASIS_ID
32: AND PPB.RATE_ID=PGR.RATE_ID
33: AND PPB.RATE_ID=PRV.RATE_ID

Line 43: , PER_ALL_ASSIGNMENTS_F ASG

39:
40: cursor grade_name IS
41: SELECT GRA.NAME
42: FROM PER_GRADES_VL GRA
43: , PER_ALL_ASSIGNMENTS_F ASG
44: WHERE ASG.ASSIGNMENT_ID=p_assignment_id
45: AND ASG.GRADE_ID=GRA.GRADE_ID
46: AND p_date BETWEEN asg.effective_start_date
47: AND asg.effective_end_date;

Line 86: , per_all_assignments_f asg

82: , pee.element_entry_id
83: from pay_element_entry_values_f pev
84: , pay_element_entries_f pee
85: , per_pay_bases ppb
86: , per_all_assignments_f asg
87: where asg.assignment_id=p_assignment_id
88: and NVL(p_change_date,to_date('31-12-4127','DD-MM-YYYY')) between
89: asg.effective_start_date and asg.effective_end_date
90: and NVL(p_change_date,to_date('31-12-4127','DD-MM-YYYY')) between

Line 175: from per_all_assignments_f

171: ,p_grade_uom OUT NOCOPY VARCHAR2) IS
172:
173: Cursor bus_grp IS
174: select business_group_id
175: from per_all_assignments_f
176: where assignment_id=p_assignment_id
177: and p_date BETWEEN
178: effective_start_date AND
179: effective_end_date;

Line 294: FROM PER_ALL_ASSIGNMENTS_F PAF

290: l_pay_annualization_factor NUMBER;
291:
292: CURSOR c_pay_basis is
293: SELECT PAF.PAY_BASIS_ID
294: FROM PER_ALL_ASSIGNMENTS_F PAF
295: WHERE PAF.ASSIGNMENT_ID=p_assignment_id
296: AND p_effective_date BETWEEN
297: PAF.EFFECTIVE_START_DATE AND
298: PAF.EFFECTIVE_END_DATE;

Line 473: , per_all_assignments_f paf

469: cursor payroll is
470: select prl.payroll_name
471: , tpt.number_per_fiscal_year
472: from pay_all_payrolls_f prl
473: , per_all_assignments_f paf
474: , per_time_period_types tpt
475: where paf.assignment_id=p_assignment_id
476: and p_date between paf.effective_start_date
477: and paf.effective_end_date

Line 533: from per_all_assignments_f asg

529: ,'M',12
530: ,'W',52
531: ,'D',365
532: ,1)
533: from per_all_assignments_f asg
534: where asg.assignment_id =p_assignment_id
535: and p_date between asg.effective_start_date
536: and asg.effective_end_date;
537:

Line 581: , per_all_assignments_f asg

577: ,'W',52
578: ,'D',365
579: ,1)
580: from hr_all_positions pos
581: , per_all_assignments_f asg
582: where asg.assignment_id =p_assignment_id
583: and p_date between asg.effective_start_date
584: and asg.effective_end_date
585: and asg.position_id=pos.position_id;

Line 596: , per_all_assignments_f asg

592: ,'W',52
593: ,'D',365
594: ,1)
595: from HR_ORGANIZATION_INFORMATION org
596: , per_all_assignments_f asg
597: where asg.assignment_id =p_assignment_id
598: and p_date between asg.effective_start_date
599: and asg.effective_end_date
600: and asg.organization_id=org.organization_id(+)

Line 612: , per_all_assignments_f asg

608: ,'W',52
609: ,'D',365
610: ,1)
611: from per_business_groups bus
612: , per_all_assignments_f asg
613: where asg.assignment_id =p_assignment_id
614: and p_date between asg.effective_start_date
615: and asg.effective_end_date
616: and asg.business_group_id=bus.business_group_id;