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 960: ln_payroll_id per_all_assignments_f.payroll_id%type;

956: ln_old_pay_annual_factor number default null;
957: lv_old_salary_basis_name per_pay_bases.name%type default null;
958: lv_excep_message varchar2(4000) default null;
959: lv_salary_basis_change_type varchar2(30) default 'NEW';
960: ln_payroll_id per_all_assignments_f.payroll_id%type;
961: lb_savepoint_exists boolean default null;
962: lb_changed boolean default false;
963:
964: lv_sal_rev_period_frequency

Line 965: per_all_assignments_f.sal_review_period_frequency%TYPE;

961: lb_savepoint_exists boolean default null;
962: lb_changed boolean default false;
963:
964: lv_sal_rev_period_frequency
965: per_all_assignments_f.sal_review_period_frequency%TYPE;
966: lv_message varchar2(32000) default null;
967: ld_temp_date date default null;
968: ln_prev_salary2 number default null;
969:

Line 978: FROM per_all_assignments_f paf

974: ,paf.business_group_id
975: ,paf.assignment_type
976: ,ppb.name old_salary_basis_name
977: ,ppb.pay_annualization_factor old_pay_annual_factor
978: FROM per_all_assignments_f paf
979: ,per_pay_bases ppb
980: WHERE assignment_id = p_assignment_id
981: and p_effective_date between effective_start_date
982: and effective_end_date

Line 1000: lv_applicant_asg_type per_all_assignments_f.assignment_type%type

996: and pro2.change_date < p_effective_date);
997: -- 05/11/02 - Bug 2340234 Fix Begins
998:
999: -- Bug 2355929 Fix Begins
1000: lv_applicant_asg_type per_all_assignments_f.assignment_type%type
1001: default null;
1002:
1003: -- Bug 2355929 Fix Ends
1004: ln_job_id number default null;

Line 1941: FROM per_all_assignments_f paf

1937: Cursor c_assignment IS
1938: SELECT
1939: paf.BUSINESS_GROUP_ID,
1940: paf.payroll_id
1941: FROM per_all_assignments_f paf
1942: WHERE paf.assignment_id = p_assignment_id
1943: AND NVL(p_effective_date, TRUNC(SYSDATE)) BETWEEN
1944: paf.effective_start_date
1945: AND paf.effective_end_date

Line 1983: l_payroll_id per_all_assignments_f.payroll_id%TYPE;

1979: lv_exists VARCHAR2(1);
1980: ld_payroll_start_date DATE ;
1981: message VARCHAR2(500);
1982: temp VARCHAR2(100);
1983: l_payroll_id per_all_assignments_f.payroll_id%TYPE;
1984: l_bg_id per_all_assignments_f.business_group_id%TYPE;
1985: l_person_type VARCHAR2(5) := 'E';
1986: BEGIN
1987:

Line 1984: l_bg_id per_all_assignments_f.business_group_id%TYPE;

1980: ld_payroll_start_date DATE ;
1981: message VARCHAR2(500);
1982: temp VARCHAR2(100);
1983: l_payroll_id per_all_assignments_f.payroll_id%TYPE;
1984: l_bg_id per_all_assignments_f.business_group_id%TYPE;
1985: l_person_type VARCHAR2(5) := 'E';
1986: BEGIN
1987:
1988: hr_utility.set_location(' Entering:' || l_proc,5);

Line 2134: FROM per_all_assignments_f asg,

2130:
2131: CURSOR c_assignment_status IS
2132: SELECT ast.per_system_status,
2133: ptp.status
2134: FROM per_all_assignments_f asg,
2135: per_time_periods ptp,
2136: per_assignment_status_types ast
2137: WHERE asg.assignment_id = p_assignment_id
2138: AND asg.assignment_status_type_id = ast.assignment_status_type_id

Line 2146: FROM per_all_assignments_f

2142: AND asg.payroll_id=ptp.payroll_id;
2143:
2144: CURSOR c_future_assignment_changes IS
2145: Select 'Y'
2146: FROM per_all_assignments_f
2147: WHERE effective_start_date > to_date(p_effective_date,'RRRR-MM-DD')
2148: AND assignment_id = p_assignment_id
2149: AND business_group_id = p_bg_id ;
2150:

Line 3943: ln_assignment_id per_all_assignments_f.assignment_id%type;

3939: lv_action_value VARCHAR2(30);
3940: ln_transaction_id NUMBER ;
3941: ln_transaction_step_id NUMBER ;
3942: message VARCHAR2(5000) := '';
3943: ln_assignment_id per_all_assignments_f.assignment_id%type;
3944:
3945: -- 04/19/02 Salary Basis Enhancement Change Begins
3946: lb_inv_next_sal_date_warning boolean default false;
3947: lb_proposed_salary_warning boolean default false;

Line 5867: ln_payroll_id per_all_assignments_f.payroll_id%type

5863: lb_proposed_salary_warning boolean default false;
5864: lb_approved_warning boolean default false;
5865: lb_payroll_warning boolean default false;
5866: lv_warning_msg_name varchar2(8000) default null;
5867: ln_payroll_id per_all_assignments_f.payroll_id%type
5868: default null;
5869: -- 04/19/02 Salary Basis Enhancement Change Ends
5870: l_effective_date VARCHAR2(100) default null;
5871:

Line 6251: per_all_assignments_f asf,

6247: asf.pay_basis_id,
6248: pay.proposed_salary_n,
6249: pb.name
6250: from
6251: per_all_assignments_f asf,
6252: per_pay_proposals pay,
6253: per_pay_bases pb,
6254: pay_input_values_f pv
6255: where asf.person_id = p_person_id