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 212: from per_all_assignments_f

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

Line 247: per_all_assignments_f paaf,

243: CURSOR get_uom_cur
244: IS
245: SELECT piv.uom
246: FROM pay_element_types_f pet,
247: per_all_assignments_f paaf,
248: pay_input_values_f piv,
249: per_pay_bases ppb,
250: per_pay_proposals ppp
251: WHERE ppp.pay_proposal_id = p_pay_proposal_id

Line 439: from per_all_assignments_f

435: l_last_payroll_dt date;
436:
437: cursor c1(p_assignment_id number) is
438: select min(effective_start_date)
439: from per_all_assignments_f
440: where assignment_id = p_assignment_id;
441:
442: cursor csr_last_dt is
443: ---removed nvl from query, now returns null when no payroll run bug#9612944

Line 446: per_all_assignments_f paf,

442: cursor csr_last_dt is
443: ---removed nvl from query, now returns null when no payroll run bug#9612944
444: Select /*+ use_nl(paf paa) */ max(ppa.date_earned)
445: from pay_assignment_actions paa,
446: per_all_assignments_f paf,
447: pay_payroll_actions ppa
448: where paf.assignment_id = p_assignment_id
449: and (paf.effective_end_date >= l_asg_start_date
450: and paf.effective_start_date <= hr_general.end_of_time)

Line 539: FROM PER_ALL_ASSIGNMENTS_F PAF

535: l_pay_annualization_factor NUMBER;
536:
537: CURSOR c_pay_basis is
538: SELECT PAF.PAY_BASIS_ID
539: FROM PER_ALL_ASSIGNMENTS_F PAF
540: WHERE PAF.ASSIGNMENT_ID=p_assignment_id
541: AND p_effective_date BETWEEN
542: PAF.EFFECTIVE_START_DATE AND
543: PAF.EFFECTIVE_END_DATE;

Line 564: , per_all_assignments_f paf

560:
561: CURSOR payroll is
562: select tpt.number_per_fiscal_year
563: from pay_all_payrolls_f prl
564: , per_all_assignments_f paf
565: , per_time_period_types tpt
566: where paf.assignment_id=p_assignment_id
567: and p_effective_date between paf.effective_start_date
568: and paf.effective_end_date

Line 607: from per_all_assignments_f paa

603: l_grade per_grades_vl.name%type :=null ;
604:
605: cursor csr_grade is
606: select HR_GENERAL.DECODE_GRADE(paa.grade_id) as grade
607: from per_all_assignments_f paa
608: where paa.assignment_id = p_assignment_id
609: and p_effective_date between paa.effective_start_date and paa.effective_end_date;
610: begin
611: open csr_grade;

Line 654: ,per_all_assignments_f paa

650: select pet.input_currency_code as currency_code
651: from per_pay_bases ppb
652: ,pay_input_values_f piv
653: ,pay_element_types_f pet
654: ,per_all_assignments_f paa
655: where paa.pay_basis_id = ppb.pay_basis_id
656: and ppb.input_value_id = piv.input_value_id
657: and piv.element_type_id = pet.element_type_id
658: and paa.assignment_id = p_assignment_id

Line 683: ,per_all_assignments_f paa

679: and lookup_code = p_lookup_code;
680: cursor csr_table is
681: select description
682: from pay_all_payrolls_f pap
683: ,per_all_assignments_f paa
684: ,hr_lookups
685: where pap.payroll_id = paa.payroll_id
686: and paa.assignment_id = p_assignment_id
687: and p_effective_date between paa.effective_start_date and paa.effective_end_date

Line 694: ,per_all_assignments_f paa

690: cursor csr_period_table is
691: select nvl(DESCRIPTION,ptt.period_type)
692: from PER_TIME_PERIOD_TYPES ptt
693: ,pay_all_payrolls_f pap
694: ,per_all_assignments_f paa
695: where pap.payroll_id = paa.payroll_id
696: and paa.assignment_id = p_assignment_id
697: and p_effective_date between paa.effective_start_date and paa.effective_end_date
698: and ptt.period_type = pap.period_type;

Line 789: from per_assignment_budget_values_f abv, per_all_assignments_f asg,

785: RETURN NUMBER IS
786: l_fte number;
787: cursor c1(p_assignment_id number, p_effective_date date) is
788: select abv.value
789: from per_assignment_budget_values_f abv, per_all_assignments_f asg,
790: per_assignment_status_types ast
791: where asg.assignment_id = p_assignment_id
792: and abv.assignment_id = asg.assignment_id
793: and asg.assignment_type in ('E', 'C')

Line 819: FROM per_all_assignments_f paaf, per_pay_bases ppb

815:
816: CURSOR csr_annualization_factor
817: IS
818: SELECT ppb.pay_annualization_factor
819: FROM per_all_assignments_f paaf, per_pay_bases ppb
820: WHERE paaf.assignment_id = p_assignment_id
821: AND p_change_date BETWEEN paaf.effective_start_date
822: AND paaf.effective_end_date
823: AND ppb.pay_basis_id = paaf.pay_basis_id;

Line 844: per_all_assignments_f paaf,

840: CURSOR currency
841: IS
842: SELECT pet.input_currency_code
843: FROM pay_element_types_f pet,
844: per_all_assignments_f paaf,
845: pay_input_values_f piv,
846: per_pay_bases ppb
847: WHERE paaf.assignment_id = p_assignment_id
848: AND p_change_date BETWEEN paaf.effective_start_date

Line 895: per_all_assignments_f paaf,

891: CURSOR currency
892: IS
893: SELECT pet.input_currency_code,piv.uom
894: FROM pay_element_types_f pet,
895: per_all_assignments_f paaf,
896: pay_input_values_f piv,
897: per_pay_bases ppb
898: WHERE paaf.assignment_id = p_assignment_id
899: AND p_change_date BETWEEN paaf.effective_start_date

Line 942: FROM per_all_assignments_f paaf, per_pay_bases ppb

938:
939: CURSOR csr_pay_basis
940: IS
941: SELECT ppb.NAME
942: FROM per_all_assignments_f paaf, per_pay_bases ppb
943: WHERE paaf.assignment_id = p_assignment_id
944: AND p_change_date BETWEEN paaf.effective_start_date
945: AND paaf.effective_end_date
946: AND ppb.pay_basis_id = paaf.pay_basis_id;

Line 1710: from per_assignment_budget_values_f abv, per_all_assignments_f asg,

1706: function get_assignment_fte(p_assignment_id number, p_effective_date date) return number is
1707: l_fte number := 0;
1708: cursor c1(p_assignment_id number, p_effective_date date) is
1709: select nvl(abv.value,0)
1710: from per_assignment_budget_values_f abv, per_all_assignments_f asg,
1711: per_assignment_status_types ast
1712: where asg.assignment_id = p_assignment_id
1713: and abv.assignment_id = asg.assignment_id
1714: and asg.assignment_type in ('E', 'C')

Line 1736: FROM per_all_assignments_f paaf, per_pay_bases ppb

1732:
1733: CURSOR csr_pay_basis
1734: IS
1735: SELECT ppb.Pay_basis
1736: FROM per_all_assignments_f paaf, per_pay_bases ppb
1737: WHERE paaf.assignment_id = p_assignment_id
1738: AND p_change_date BETWEEN paaf.effective_start_date
1739: AND paaf.effective_end_date
1740: AND ppb.pay_basis_id = paaf.pay_basis_id;

Line 1757: from per_all_assignments_f

1753: return date is
1754: l_next_sb_date date;
1755: CURSOR c_next_sb_date(p_assignment_id IN NUMBER, p_from_date IN DATE) is
1756: select min(effective_start_date)
1757: from per_all_assignments_f
1758: where assignment_id = p_assignment_id
1759: and effective_start_date > p_from_date
1760: and pay_basis_id not in
1761: (select pay_basis_id

Line 1762: from per_all_assignments_f

1758: where assignment_id = p_assignment_id
1759: and effective_start_date > p_from_date
1760: and pay_basis_id not in
1761: (select pay_basis_id
1762: from per_all_assignments_f
1763: where assignment_id = p_assignment_id
1764: and p_from_date
1765: between effective_start_date and effective_end_date );
1766: begin

Line 1784: from per_all_assignments_f

1780: l_pay_basis_id number;
1781:
1782: CURSOR c_pay_basis_id is
1783: select pay_basis_id
1784: from per_all_assignments_f
1785: where assignment_id = p_assignment_id
1786: and p_from_date
1787: between effective_start_date and effective_end_date;
1788: BEGIN

Line 1805: from per_all_assignments_f

1801: CURSOR c_asg_sal_basis_end_dt(p_assignment_id IN NUMBER,
1802: p_pay_basis_id IN NUMBER,
1803: p_from_date IN DATE) is
1804: select min(effective_start_date) - 1
1805: from per_all_assignments_f
1806: where assignment_id = p_assignment_id
1807: and effective_start_date >= p_from_date
1808: and nvl(pay_basis_id,-1) <> p_pay_basis_id;
1809: begin