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.HR_PAY_RATE_SS dependencies on PER_ALL_ASSIGNMENTS_F

Line 38: from per_all_assignments_f paf,

34: l_proc varchar2(200) := g_package || 'check_ele_eligibility';
35:
36: Cursor c1 (p_aid number, p_date date) IS
37: select ivf.element_type_id
38: from per_all_assignments_f paf,
39: per_pay_bases pb, pay_input_values_f ivf
40: where paf.assignment_id = p_aid
41: --and paf.assignment_type = 'E'
42: and pb.pay_basis_id = paf.pay_basis_id

Line 95: l_assignment_id per_all_assignments_f.assignment_id%type default null;

91: result out nocopy varchar2 ) IS
92:
93:
94: l_proc varchar2(200) := g_package || 'check_mid_pay_period_change';
95: l_assignment_id per_all_assignments_f.assignment_id%type default null;
96: l_payroll_id per_all_assignments_f.payroll_id%type default null;
97: l_old_pay_basis_id per_all_assignments_f.pay_basis_id%type default null;
98: l_new_pay_basis_id per_all_assignments_f.pay_basis_id%type default null;
99: l_pay_period_start_date date default null;

Line 96: l_payroll_id per_all_assignments_f.payroll_id%type default null;

92:
93:
94: l_proc varchar2(200) := g_package || 'check_mid_pay_period_change';
95: l_assignment_id per_all_assignments_f.assignment_id%type default null;
96: l_payroll_id per_all_assignments_f.payroll_id%type default null;
97: l_old_pay_basis_id per_all_assignments_f.pay_basis_id%type default null;
98: l_new_pay_basis_id per_all_assignments_f.pay_basis_id%type default null;
99: l_pay_period_start_date date default null;
100: l_pay_period_end_date date default null;

Line 97: l_old_pay_basis_id per_all_assignments_f.pay_basis_id%type default null;

93:
94: l_proc varchar2(200) := g_package || 'check_mid_pay_period_change';
95: l_assignment_id per_all_assignments_f.assignment_id%type default null;
96: l_payroll_id per_all_assignments_f.payroll_id%type default null;
97: l_old_pay_basis_id per_all_assignments_f.pay_basis_id%type default null;
98: l_new_pay_basis_id per_all_assignments_f.pay_basis_id%type default null;
99: l_pay_period_start_date date default null;
100: l_pay_period_end_date date default null;
101:

Line 98: l_new_pay_basis_id per_all_assignments_f.pay_basis_id%type default null;

94: l_proc varchar2(200) := g_package || 'check_mid_pay_period_change';
95: l_assignment_id per_all_assignments_f.assignment_id%type default null;
96: l_payroll_id per_all_assignments_f.payroll_id%type default null;
97: l_old_pay_basis_id per_all_assignments_f.pay_basis_id%type default null;
98: l_new_pay_basis_id per_all_assignments_f.pay_basis_id%type default null;
99: l_pay_period_start_date date default null;
100: l_pay_period_end_date date default null;
101:
102: l_asg_txn_step_id hr_api_transaction_steps.transaction_step_id%type

Line 133: FROM per_all_assignments_f

129:
130: -- Get existing assignment data
131: CURSOR csr_get_old_asg_data IS
132: SELECT pay_basis_id
133: FROM per_all_assignments_f
134: WHERE assignment_id = l_assignment_id
135: AND l_effective_date between effective_start_date
136: and effective_end_date
137: AND assignment_type = 'E';

Line 687: FROM per_all_assignments_f paf

683:
684: -- cursor to get the grade ladder id from the assignment record
685: CURSOR lc_asg_grade_ladder_id IS
686: SELECT paf.grade_ladder_pgm_id,paf.assignment_type
687: FROM per_all_assignments_f paf
688: WHERE assignment_id = p_assignment_id
689: and p_effective_date between effective_start_date
690: and effective_end_date;
691:

Line 695: (p_grade_ladder_id in per_all_assignments_f.grade_ladder_pgm_id%TYPE,

691:
692: -- cursor to find whether assigned grade ladder id updates
693: -- the salary using Grade Step Progression
694: CURSOR lc_sal_updateable_grade_ladder
695: (p_grade_ladder_id in per_all_assignments_f.grade_ladder_pgm_id%TYPE,
696: p_effective_date in date
697: ) IS
698: select pgm_id from ben_pgm_f
699: where

Line 712: lv_applicant_asg_type PER_ALL_ASSIGNMENTS_F.assignment_type%TYPE

708:
709:
710:
711: -- Bug 2355929 Fix Begins
712: lv_applicant_asg_type PER_ALL_ASSIGNMENTS_F.assignment_type%TYPE
713: default null;
714: -- Bug 2355929 Fix Ends
715: --ln_job_id number default null;
716: -- GSP

Line 717: lc_temp_grade_ladder_id PER_ALL_ASSIGNMENTS_F.grade_ladder_pgm_id%TYPE default null;

713: default null;
714: -- Bug 2355929 Fix Ends
715: --ln_job_id number default null;
716: -- GSP
717: lc_temp_grade_ladder_id PER_ALL_ASSIGNMENTS_F.grade_ladder_pgm_id%TYPE default null;
718: p_old_grade_ladder_id PER_ALL_ASSIGNMENTS_F.grade_ladder_pgm_id%TYPE default null;
719: p_new_grade_ladder_id PER_ALL_ASSIGNMENTS_F.grade_ladder_pgm_id%TYPE default null;
720: ln_txn_grade_ladder_id PER_ALL_ASSIGNMENTS_F.grade_ladder_pgm_id%TYPE default null;
721:

Line 718: p_old_grade_ladder_id PER_ALL_ASSIGNMENTS_F.grade_ladder_pgm_id%TYPE default null;

714: -- Bug 2355929 Fix Ends
715: --ln_job_id number default null;
716: -- GSP
717: lc_temp_grade_ladder_id PER_ALL_ASSIGNMENTS_F.grade_ladder_pgm_id%TYPE default null;
718: p_old_grade_ladder_id PER_ALL_ASSIGNMENTS_F.grade_ladder_pgm_id%TYPE default null;
719: p_new_grade_ladder_id PER_ALL_ASSIGNMENTS_F.grade_ladder_pgm_id%TYPE default null;
720: ln_txn_grade_ladder_id PER_ALL_ASSIGNMENTS_F.grade_ladder_pgm_id%TYPE default null;
721:
722: BEGIN

Line 719: p_new_grade_ladder_id PER_ALL_ASSIGNMENTS_F.grade_ladder_pgm_id%TYPE default null;

715: --ln_job_id number default null;
716: -- GSP
717: lc_temp_grade_ladder_id PER_ALL_ASSIGNMENTS_F.grade_ladder_pgm_id%TYPE default null;
718: p_old_grade_ladder_id PER_ALL_ASSIGNMENTS_F.grade_ladder_pgm_id%TYPE default null;
719: p_new_grade_ladder_id PER_ALL_ASSIGNMENTS_F.grade_ladder_pgm_id%TYPE default null;
720: ln_txn_grade_ladder_id PER_ALL_ASSIGNMENTS_F.grade_ladder_pgm_id%TYPE default null;
721:
722: BEGIN
723:

Line 720: ln_txn_grade_ladder_id PER_ALL_ASSIGNMENTS_F.grade_ladder_pgm_id%TYPE default null;

716: -- GSP
717: lc_temp_grade_ladder_id PER_ALL_ASSIGNMENTS_F.grade_ladder_pgm_id%TYPE default null;
718: p_old_grade_ladder_id PER_ALL_ASSIGNMENTS_F.grade_ladder_pgm_id%TYPE default null;
719: p_new_grade_ladder_id PER_ALL_ASSIGNMENTS_F.grade_ladder_pgm_id%TYPE default null;
720: ln_txn_grade_ladder_id PER_ALL_ASSIGNMENTS_F.grade_ladder_pgm_id%TYPE default null;
721:
722: BEGIN
723:
724: hr_utility.set_location(' Entering:' || l_proc,5);

Line 968: ln_payroll_id per_all_assignments_f.payroll_id%type;

964: ln_old_fte_factor number default null;
965: lv_old_salary_basis_name per_pay_bases.name%type default null;
966: lv_excep_message varchar2(4000) default null;
967: lv_salary_basis_change_type varchar2(30) default 'NEW';
968: ln_payroll_id per_all_assignments_f.payroll_id%type;
969: lb_savepoint_exists boolean default null;
970: lb_changed boolean default false;
971:
972: lv_sal_rev_period_frequency

Line 973: per_all_assignments_f.sal_review_period_frequency%TYPE;

969: lb_savepoint_exists boolean default null;
970: lb_changed boolean default false;
971:
972: lv_sal_rev_period_frequency
973: per_all_assignments_f.sal_review_period_frequency%TYPE;
974: lv_message varchar2(32000) default null;
975: ld_temp_date date default null;
976: ln_prev_salary2 number default null;
977:

Line 986: FROM per_all_assignments_f paf

982: ,paf.business_group_id
983: ,paf.assignment_type
984: ,ppb.name old_salary_basis_name
985: ,ppb.pay_annualization_factor old_pay_annual_factor
986: FROM per_all_assignments_f paf
987: ,per_pay_bases ppb
988: WHERE assignment_id = p_assignment_id
989: and p_effective_date between effective_start_date
990: and effective_end_date

Line 1012: per_all_assignments_f paf,

1008: select paf.pay_basis_id,
1009: paf.assignment_type,
1010: ppp.proposed_salary_n
1011: from
1012: per_all_assignments_f paf,
1013: per_pay_proposals ppp
1014: where paf.assignment_id = p_assignment_id
1015: and p_effective_date between paf.effective_start_date and paf.effective_end_date
1016: and ppp.assignment_id = paf.assignment_id

Line 1023: lv_applicant_asg_type per_all_assignments_f.assignment_type%type

1019: p_offered_salary_basis_id number;
1020: p_offered_asg_type varchar2(2);
1021:
1022: -- Bug 2355929 Fix Begins
1023: lv_applicant_asg_type per_all_assignments_f.assignment_type%type
1024: default null;
1025:
1026: -- Bug 2355929 Fix Ends
1027: ln_job_id number default null;

Line 1598: FROM PER_ALL_ASSIGNMENTS_F PAF, per_pay_bases ppb

1594: ln_ann_sal number;
1595:
1596: cursor grade_basis is
1597: SELECT ppb.rate_basis
1598: FROM PER_ALL_ASSIGNMENTS_F PAF, per_pay_bases ppb
1599: WHERE PAF.ASSIGNMENT_ID=p_assignment_id
1600: AND p_date BETWEEN PAF.EFFECTIVE_START_DATE AND PAF.EFFECTIVE_END_DATE
1601: and paf.pay_basis_id = ppb.pay_basis_id;
1602:

Line 1609: , PER_ALL_ASSIGNMENTS_F ASG

1605: , fnd_number.canonical_to_number(PGR.MAXIMUM)
1606: , fnd_number.canonical_to_number(PGR.MID_VALUE)
1607: FROM PER_PAY_BASES PPB
1608: , PAY_GRADE_RULES_F PGR
1609: , PER_ALL_ASSIGNMENTS_F ASG
1610: WHERE ASG.ASSIGNMENT_ID=p_assignment_id
1611: AND PPB.PAY_BASIS_ID=ASG.PAY_BASIS_ID
1612: AND PPB.RATE_ID=PGR.RATE_ID
1613: AND ASG.GRADE_ID=PGR.GRADE_OR_SPINAL_POINT_ID

Line 2041: FROM per_all_assignments_f paf

2037: Cursor c_assignment IS
2038: SELECT
2039: paf.BUSINESS_GROUP_ID,
2040: paf.payroll_id
2041: FROM per_all_assignments_f paf
2042: WHERE paf.assignment_id = p_assignment_id
2043: AND NVL(p_effective_date, TRUNC(SYSDATE)) BETWEEN
2044: paf.effective_start_date
2045: AND paf.effective_end_date

Line 2083: l_payroll_id per_all_assignments_f.payroll_id%TYPE;

2079: lv_exists VARCHAR2(1);
2080: ld_payroll_start_date DATE ;
2081: message VARCHAR2(500);
2082: temp VARCHAR2(100);
2083: l_payroll_id per_all_assignments_f.payroll_id%TYPE;
2084: l_bg_id per_all_assignments_f.business_group_id%TYPE;
2085: l_person_type VARCHAR2(5) := 'E';
2086: BEGIN
2087:

Line 2084: l_bg_id per_all_assignments_f.business_group_id%TYPE;

2080: ld_payroll_start_date DATE ;
2081: message VARCHAR2(500);
2082: temp VARCHAR2(100);
2083: l_payroll_id per_all_assignments_f.payroll_id%TYPE;
2084: l_bg_id per_all_assignments_f.business_group_id%TYPE;
2085: l_person_type VARCHAR2(5) := 'E';
2086: BEGIN
2087:
2088: hr_utility.set_location(' Entering:' || l_proc,5);

Line 2235: FROM per_all_assignments_f asg,

2231:
2232: CURSOR c_assignment_status IS
2233: SELECT ast.per_system_status,
2234: ptp.status
2235: FROM per_all_assignments_f asg,
2236: per_time_periods ptp,
2237: per_assignment_status_types ast
2238: WHERE asg.assignment_id = p_assignment_id
2239: AND asg.assignment_status_type_id = ast.assignment_status_type_id

Line 2247: FROM per_all_assignments_f

2243: AND asg.payroll_id=ptp.payroll_id;
2244:
2245: CURSOR c_future_assignment_changes IS
2246: Select 'Y'
2247: FROM per_all_assignments_f
2248: WHERE effective_start_date > to_date(p_effective_date,'RRRR-MM-DD')
2249: AND assignment_id = p_assignment_id
2250: AND business_group_id = p_bg_id ;
2251:

Line 4100: ln_assignment_id per_all_assignments_f.assignment_id%type;

4096: lv_action_value VARCHAR2(30);
4097: ln_transaction_id NUMBER ;
4098: ln_transaction_step_id NUMBER ;
4099: message VARCHAR2(5000) := '';
4100: ln_assignment_id per_all_assignments_f.assignment_id%type;
4101:
4102: -- 04/19/02 Salary Basis Enhancement Change Begins
4103: lb_inv_next_sal_date_warning boolean default false;
4104: lb_proposed_salary_warning boolean default false;

Line 6044: ln_payroll_id per_all_assignments_f.payroll_id%type

6040: lb_proposed_salary_warning boolean default false;
6041: lb_approved_warning boolean default false;
6042: lb_payroll_warning boolean default false;
6043: lv_warning_msg_name varchar2(8000) default null;
6044: ln_payroll_id per_all_assignments_f.payroll_id%type
6045: default null;
6046: -- 04/19/02 Salary Basis Enhancement Change Ends
6047: l_effective_date VARCHAR2(100) default null;
6048: ld_effective_date date default null;

Line 6553: per_all_assignments_f asf,

6549: asf.pay_basis_id,
6550: pay.proposed_salary_n,
6551: pb.name
6552: from
6553: per_all_assignments_f asf,
6554: per_pay_proposals pay,
6555: per_pay_bases pb,
6556: pay_input_values_f pv
6557: where asf.person_id = p_person_id