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

Line 11: Per_all_assignments_F paa

7: function Check_GSP_Manual_Override (p_assignment_id in NUMBER, p_effective_date in DATE) RETURN VARCHAR2 is
8: Cursor Grade_Ladder Is
9: Select Nvl(Gsp_Allow_Override_Flag,'Y')
10: From Ben_Pgm_f Pgm,
11: Per_all_assignments_F paa
12: Where paa.Assignment_Id = p_assignment_id
13: and p_effective_date between paa.Effective_Start_Date and paa.Effective_End_Date
14: and paa.GRADE_LADDER_PGM_ID is Not NULL
15: and pgm.pgm_id = paa.Grade_Ladder_Pgm_Id

Line 60: from per_all_assignments_f paa

56: ,ppb.rate_basis
57: ,pet.input_currency_code as element_currency_code
58: ,PER_SALADMIN_UTILITY.get_grade_currency(paa.grade_id,ppb.rate_id,p_effective_date,paa.business_group_id) as grade_rate_currency_code
59: ,ben_cwb_person_info_pkg.get_grd_min_val(paa.grade_id,ppb.rate_id,p_effective_date)
60: from per_all_assignments_f paa
61: ,per_pay_bases ppb
62: ,pay_input_values_f piv
63: ,pay_element_types_f pet
64: where paa.assignment_id = p_assignment_id

Line 118: from per_all_assignments_f paa

114: ,ppb.rate_basis
115: ,pet.input_currency_code as element_currency_code
116: ,PER_SALADMIN_UTILITY.get_grade_currency(paa.grade_id,ppb.rate_id,p_effective_date,paa.business_group_id) as grade_rate_currency_code
117: ,ben_cwb_person_info_pkg.get_grd_max_val(paa.grade_id,ppb.rate_id,p_effective_date)
118: from per_all_assignments_f paa
119: ,per_pay_bases ppb
120: ,pay_input_values_f piv
121: ,pay_element_types_f pet
122: where paa.assignment_id = p_assignment_id

Line 161: ,p_period in per_all_assignments_f.sal_review_period%TYPE

157:
158:
159: function derive_next_sal_perf_date
160: (p_change_date in per_pay_proposals.change_date%TYPE
161: ,p_period in per_all_assignments_f.sal_review_period%TYPE
162: ,p_frequency in per_all_assignments_f.sal_review_period_frequency%TYPE
163: )
164: Return Date is
165: l_derived_date date;

Line 162: ,p_frequency in per_all_assignments_f.sal_review_period_frequency%TYPE

158:
159: function derive_next_sal_perf_date
160: (p_change_date in per_pay_proposals.change_date%TYPE
161: ,p_period in per_all_assignments_f.sal_review_period%TYPE
162: ,p_frequency in per_all_assignments_f.sal_review_period_frequency%TYPE
163: )
164: Return Date is
165: l_derived_date date;
166: l_num_months number(15) := 0;

Line 208: from per_all_assignments_f

204: --
205: cursor csr_sal_review_details is
206: select sal_review_period,
207: sal_review_period_frequency
208: from per_all_assignments_f
209: where assignment_id = p_assignment_id
210: and business_group_id + 0 = p_business_group_id
211: and p_change_date between effective_start_date
212: and nvl(effective_end_date, hr_general.end_of_time);

Line 243: per_all_assignments_f paaf,

239: CURSOR get_uom_cur
240: IS
241: SELECT piv.uom
242: FROM pay_element_types_f pet,
243: per_all_assignments_f paaf,
244: pay_input_values_f piv,
245: per_pay_bases ppb,
246: per_pay_proposals ppp
247: WHERE ppp.pay_proposal_id = p_pay_proposal_id

Line 434: from per_all_assignments_f

430: l_asg_start_date date;
431: l_last_payroll_dt date;
432: cursor c1(p_assignment_id number) is
433: select min(effective_start_date)
434: from per_all_assignments_f
435: where assignment_id = p_assignment_id;
436: begin
437: open c1(p_assignment_id);
438: fetch c1 into l_asg_start_date;

Line 508: FROM PER_ALL_ASSIGNMENTS_F PAF

504: l_pay_annualization_factor NUMBER;
505:
506: CURSOR c_pay_basis is
507: SELECT PAF.PAY_BASIS_ID
508: FROM PER_ALL_ASSIGNMENTS_F PAF
509: WHERE PAF.ASSIGNMENT_ID=p_assignment_id
510: AND p_effective_date BETWEEN
511: PAF.EFFECTIVE_START_DATE AND
512: PAF.EFFECTIVE_END_DATE;

Line 533: , per_all_assignments_f paf

529:
530: CURSOR payroll is
531: select tpt.number_per_fiscal_year
532: from pay_all_payrolls_f prl
533: , per_all_assignments_f paf
534: , per_time_period_types tpt
535: where paf.assignment_id=p_assignment_id
536: and p_effective_date between paf.effective_start_date
537: and paf.effective_end_date

Line 576: from per_all_assignments_f paa

572: l_grade per_grades_vl.name%type :=null ;
573:
574: cursor csr_grade is
575: select HR_GENERAL.DECODE_GRADE(paa.grade_id) as grade
576: from per_all_assignments_f paa
577: where paa.assignment_id = p_assignment_id
578: and p_effective_date between paa.effective_start_date and paa.effective_end_date;
579: begin
580: open csr_grade;

Line 623: ,per_all_assignments_f paa

619: select pet.input_currency_code as currency_code
620: from per_pay_bases ppb
621: ,pay_input_values_f piv
622: ,pay_element_types_f pet
623: ,per_all_assignments_f paa
624: where paa.pay_basis_id = ppb.pay_basis_id
625: and ppb.input_value_id = piv.input_value_id
626: and piv.element_type_id = pet.element_type_id
627: and paa.assignment_id = p_assignment_id

Line 652: ,per_all_assignments_f paa

648: and lookup_code = p_lookup_code;
649: cursor csr_table is
650: select description
651: from pay_all_payrolls_f pap
652: ,per_all_assignments_f paa
653: ,hr_lookups
654: where pap.payroll_id = paa.payroll_id
655: and paa.assignment_id = p_assignment_id
656: and p_effective_date between paa.effective_start_date and paa.effective_end_date

Line 663: ,per_all_assignments_f paa

659: cursor csr_period_table is
660: select nvl(DESCRIPTION,ptt.period_type)
661: from PER_TIME_PERIOD_TYPES ptt
662: ,pay_all_payrolls_f pap
663: ,per_all_assignments_f paa
664: where pap.payroll_id = paa.payroll_id
665: and paa.assignment_id = p_assignment_id
666: and p_effective_date between paa.effective_start_date and paa.effective_end_date
667: and ptt.period_type = pap.period_type;

Line 758: from per_assignment_budget_values_f abv, per_all_assignments_f asg,

754: RETURN NUMBER IS
755: l_fte number;
756: cursor c1(p_assignment_id number, p_effective_date date) is
757: select abv.value
758: from per_assignment_budget_values_f abv, per_all_assignments_f asg,
759: per_assignment_status_types ast
760: where asg.assignment_id = p_assignment_id
761: and abv.assignment_id = asg.assignment_id
762: and asg.assignment_type in ('E', 'C')

Line 788: FROM per_all_assignments_f paaf, per_pay_bases ppb

784:
785: CURSOR csr_annualization_factor
786: IS
787: SELECT ppb.pay_annualization_factor
788: FROM per_all_assignments_f paaf, per_pay_bases ppb
789: WHERE paaf.assignment_id = p_assignment_id
790: AND p_change_date BETWEEN paaf.effective_start_date
791: AND paaf.effective_end_date
792: AND ppb.pay_basis_id = paaf.pay_basis_id;

Line 813: per_all_assignments_f paaf,

809: CURSOR currency
810: IS
811: SELECT pet.input_currency_code
812: FROM pay_element_types_f pet,
813: per_all_assignments_f paaf,
814: pay_input_values_f piv,
815: per_pay_bases ppb
816: WHERE paaf.assignment_id = p_assignment_id
817: AND p_change_date BETWEEN paaf.effective_start_date

Line 864: per_all_assignments_f paaf,

860: CURSOR currency
861: IS
862: SELECT pet.input_currency_code,piv.uom
863: FROM pay_element_types_f pet,
864: per_all_assignments_f paaf,
865: pay_input_values_f piv,
866: per_pay_bases ppb
867: WHERE paaf.assignment_id = p_assignment_id
868: AND p_change_date BETWEEN paaf.effective_start_date

Line 911: FROM per_all_assignments_f paaf, per_pay_bases ppb

907:
908: CURSOR csr_pay_basis
909: IS
910: SELECT ppb.NAME
911: FROM per_all_assignments_f paaf, per_pay_bases ppb
912: WHERE paaf.assignment_id = p_assignment_id
913: AND p_change_date BETWEEN paaf.effective_start_date
914: AND paaf.effective_end_date
915: AND ppb.pay_basis_id = paaf.pay_basis_id;

Line 1465: from per_assignment_budget_values_f abv, per_all_assignments_f asg,

1461: function get_assignment_fte(p_assignment_id number, p_effective_date date) return number is
1462: l_fte number := 0;
1463: cursor c1(p_assignment_id number, p_effective_date date) is
1464: select nvl(abv.value,0)
1465: from per_assignment_budget_values_f abv, per_all_assignments_f asg,
1466: per_assignment_status_types ast
1467: where asg.assignment_id = p_assignment_id
1468: and abv.assignment_id = asg.assignment_id
1469: and asg.assignment_type in ('E', 'C')

Line 1491: FROM per_all_assignments_f paaf, per_pay_bases ppb

1487:
1488: CURSOR csr_pay_basis
1489: IS
1490: SELECT ppb.Pay_basis
1491: FROM per_all_assignments_f paaf, per_pay_bases ppb
1492: WHERE paaf.assignment_id = p_assignment_id
1493: AND p_change_date BETWEEN paaf.effective_start_date
1494: AND paaf.effective_end_date
1495: AND ppb.pay_basis_id = paaf.pay_basis_id;

Line 1512: from per_all_assignments_f

1508: return date is
1509: l_next_sb_date date;
1510: CURSOR c_next_sb_date(p_assignment_id IN NUMBER, p_from_date IN DATE) is
1511: select min(effective_start_date)
1512: from per_all_assignments_f
1513: where assignment_id = p_assignment_id
1514: and effective_start_date > p_from_date
1515: and pay_basis_id not in
1516: (select pay_basis_id

Line 1517: from per_all_assignments_f

1513: where assignment_id = p_assignment_id
1514: and effective_start_date > p_from_date
1515: and pay_basis_id not in
1516: (select pay_basis_id
1517: from per_all_assignments_f
1518: where assignment_id = p_assignment_id
1519: and p_from_date
1520: between effective_start_date and effective_end_date );
1521: begin

Line 1539: from per_all_assignments_f

1535: l_pay_basis_id number;
1536:
1537: CURSOR c_pay_basis_id is
1538: select pay_basis_id
1539: from per_all_assignments_f
1540: where assignment_id = p_assignment_id
1541: and p_from_date
1542: between effective_start_date and effective_end_date;
1543: BEGIN

Line 1560: from per_all_assignments_f

1556: CURSOR c_asg_sal_basis_end_dt(p_assignment_id IN NUMBER,
1557: p_pay_basis_id IN NUMBER,
1558: p_from_date IN DATE) is
1559: select min(effective_start_date) - 1
1560: from per_all_assignments_f
1561: where assignment_id = p_assignment_id
1562: and effective_start_date >= p_from_date
1563: and nvl(pay_basis_id,-1) <> p_pay_basis_id;
1564: begin