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_PAY_BASES

Line 61: ,per_pay_bases ppb

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
65: and paa.pay_basis_id = ppb.pay_basis_id

Line 119: ,per_pay_bases ppb

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
123: and paa.pay_basis_id = ppb.pay_basis_id

Line 245: per_pay_bases ppb,

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
248: and paaf.assignment_id = ppp.assignment_id
249: and ppp.change_date BETWEEN paaf.effective_start_date

Line 519: ,PER_PAY_BASES PPB

515: SELECT HR_GENERAL.DECODE_LOOKUP('PAY_BASIS',PPB.PAY_BASIS)
516: ,PPB.PAY_ANNUALIZATION_FACTOR
517: FROM PAY_ELEMENT_TYPES_F PET
518: ,PAY_INPUT_VALUES_F PIV
519: ,PER_PAY_BASES PPB
520: WHERE PPB.PAY_BASIS_ID=L_PAY_BASIS_ID
521: AND PPB.INPUT_VALUE_ID=PIV.INPUT_VALUE_ID
522: AND p_effective_date BETWEEN
523: PIV.EFFECTIVE_START_DATE AND

Line 620: from per_pay_bases ppb

616: is
617: l_currency varchar2(100):=null ;
618: cursor csr_currency is
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

Line 783: l_annualization_factor per_pay_bases.pay_annualization_factor%TYPE;

779: p_change_date IN DATE
780: )
781: RETURN NUMBER
782: IS
783: l_annualization_factor per_pay_bases.pay_annualization_factor%TYPE;
784:
785: CURSOR csr_annualization_factor
786: IS
787: SELECT ppb.pay_annualization_factor

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 815: per_pay_bases ppb

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
818: AND paaf.effective_end_date
819: AND ppb.pay_basis_id = paaf.pay_basis_id

Line 866: per_pay_bases ppb

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
869: AND paaf.effective_end_date
870: AND ppb.pay_basis_id = paaf.pay_basis_id

Line 906: l_pay_basis per_pay_bases.NAME%TYPE;

902:
903: FUNCTION get_pay_basis (p_assignment_id IN NUMBER, p_change_date IN DATE)
904: RETURN VARCHAR2
905: IS
906: l_pay_basis per_pay_bases.NAME%TYPE;
907:
908: CURSOR csr_pay_basis
909: IS
910: SELECT ppb.NAME

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 1045: , PER_PAY_BASES PPB

1041: , PPB.PAY_ANNUALIZATION_FACTOR
1042: ,PIV.UOM
1043: FROM PAY_ELEMENT_TYPES_F PET
1044: , PAY_INPUT_VALUES_F PIV
1045: , PER_PAY_BASES PPB
1046: WHERE PPB.PAY_BASIS_ID=L_PAY_BASIS_ID
1047: AND PPB.INPUT_VALUE_ID=PIV.INPUT_VALUE_ID
1048: AND p_effective_date BETWEEN PIV.EFFECTIVE_START_DATE AND PIV.EFFECTIVE_END_DATE
1049: AND PIV.ELEMENT_TYPE_ID=PET.ELEMENT_TYPE_ID

Line 1486: l_pay_basis per_pay_bases.PAY_BASIS%TYPE;

1482:
1483: FUNCTION get_basis_lookup (p_assignment_id IN NUMBER, p_change_date IN DATE)
1484: RETURN VARCHAR2
1485: IS
1486: l_pay_basis per_pay_bases.PAY_BASIS%TYPE;
1487:
1488: CURSOR csr_pay_basis
1489: IS
1490: SELECT ppb.Pay_basis

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;