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 249: per_pay_bases ppb,

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

Line 550: ,PER_PAY_BASES PPB

546: SELECT HR_GENERAL.DECODE_LOOKUP('PAY_BASIS',PPB.PAY_BASIS)
547: ,PPB.PAY_ANNUALIZATION_FACTOR
548: FROM PAY_ELEMENT_TYPES_F PET
549: ,PAY_INPUT_VALUES_F PIV
550: ,PER_PAY_BASES PPB
551: WHERE PPB.PAY_BASIS_ID=L_PAY_BASIS_ID
552: AND PPB.INPUT_VALUE_ID=PIV.INPUT_VALUE_ID
553: AND p_effective_date BETWEEN
554: PIV.EFFECTIVE_START_DATE AND

Line 651: from per_pay_bases ppb

647: is
648: l_currency varchar2(100):=null ;
649: cursor csr_currency is
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

Line 814: l_annualization_factor per_pay_bases.pay_annualization_factor%TYPE;

810: p_change_date IN DATE
811: )
812: RETURN NUMBER
813: IS
814: l_annualization_factor per_pay_bases.pay_annualization_factor%TYPE;
815:
816: CURSOR csr_annualization_factor
817: IS
818: SELECT ppb.pay_annualization_factor

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

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

Line 897: per_pay_bases ppb

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

Line 937: l_pay_basis per_pay_bases.NAME%TYPE;

933:
934: FUNCTION get_pay_basis (p_assignment_id IN NUMBER, p_change_date IN DATE)
935: RETURN VARCHAR2
936: IS
937: l_pay_basis per_pay_bases.NAME%TYPE;
938:
939: CURSOR csr_pay_basis
940: IS
941: SELECT ppb.NAME

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

1266: , PPB.PAY_ANNUALIZATION_FACTOR
1267: ,PIV.UOM
1268: FROM PAY_ELEMENT_TYPES_F PET
1269: , PAY_INPUT_VALUES_F PIV
1270: , PER_PAY_BASES PPB
1271: WHERE PPB.PAY_BASIS_ID=L_PAY_BASIS_ID
1272: AND PPB.INPUT_VALUE_ID=PIV.INPUT_VALUE_ID
1273: AND p_effective_date BETWEEN PIV.EFFECTIVE_START_DATE AND PIV.EFFECTIVE_END_DATE
1274: AND PIV.ELEMENT_TYPE_ID=PET.ELEMENT_TYPE_ID

Line 1731: l_pay_basis per_pay_bases.PAY_BASIS%TYPE;

1727:
1728: FUNCTION get_basis_lookup (p_assignment_id IN NUMBER, p_change_date IN DATE)
1729: RETURN VARCHAR2
1730: IS
1731: l_pay_basis per_pay_bases.PAY_BASIS%TYPE;
1732:
1733: CURSOR csr_pay_basis
1734: IS
1735: SELECT ppb.Pay_basis

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;