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_SSHR_CHANGE_PAY dependencies on PER_ALL_ASSIGNMENTS_F

Line 40: Per_all_assignments_F paa

36: --
37: Cursor csr_assignment_check Is
38: Select Nvl(Gsp_Allow_Override_Flag,'Y')
39: From Ben_Pgm_f Pgm,
40: Per_all_assignments_F paa
41: Where paa.Assignment_Id = p_assignment_id
42: and p_effective_date between paa.Effective_Start_Date and paa.Effective_End_Date
43: and paa.GRADE_LADDER_PGM_ID is Not NULL
44: and pgm.pgm_id = paa.Grade_Ladder_Pgm_Id

Line 114: l_pay_basis per_all_assignments_f.pay_basis_id%type;

110: l_txn_basis number;
111: l_ast_basis number;
112: l_transaction_id number;
113: l_transaction_step_id number;
114: l_pay_basis per_all_assignments_f.pay_basis_id%type;
115: --
116: Cursor asg_step is
117: select transaction_id,transaction_step_id
118: from hr_api_transaction_steps

Line 137: from per_all_assignments_f

133: where TRANSACTION_STEP_ID = c_transaction_step_id);
134: --
135: Cursor csr_pay_basis_exists(c_assignment_id number,c_effective_date date) IS
136: select pay_basis_id
137: from per_all_assignments_f
138: where assignment_id = c_assignment_id
139: and c_effective_date between effective_start_date and effective_end_date;
140: --
141: Cursor csr_txn_prop is

Line 285: l_asg_rec per_all_assignments_f%ROWTYPE;

281: l_result varchar2(100);
282: l_count number := 1;
283: l_update_mode boolean := true;
284: --
285: l_asg_rec per_all_assignments_f%ROWTYPE;
286: --
287: Cursor csg_asg_details is
288: Select * from per_all_assignments_f
289: Where assignment_id = p_assignment_id

Line 288: Select * from per_all_assignments_f

284: --
285: l_asg_rec per_all_assignments_f%ROWTYPE;
286: --
287: Cursor csg_asg_details is
288: Select * from per_all_assignments_f
289: Where assignment_id = p_assignment_id
290: and trunc(p_effective_date) between effective_start_date and effective_end_date;
291: --
292: Begin

Line 1290: from per_all_assignments_f

1286: and hat.status<>'AC';
1287:
1288: Cursor csr_asg_basis_change_date IS
1289: select effective_start_date date_value
1290: from per_all_assignments_f
1291: where assignment_id = p_assignment_id
1292: and effective_start_date >= p_effective_date
1293: and pay_basis_id <> (Select pay_basis_id from per_all_assignments_f
1294: where assignment_id = p_assignment_id

Line 1293: and pay_basis_id <> (Select pay_basis_id from per_all_assignments_f

1289: select effective_start_date date_value
1290: from per_all_assignments_f
1291: where assignment_id = p_assignment_id
1292: and effective_start_date >= p_effective_date
1293: and pay_basis_id <> (Select pay_basis_id from per_all_assignments_f
1294: where assignment_id = p_assignment_id
1295: and p_effective_date between effective_start_date and effective_end_date)
1296: order by date_value desc;
1297: l_date date;

Line 1483: per_all_assignments_f paaf,

1479: null PRIOR_PAY_TRANSACTION_ID,
1480: null APPROVED,
1481: pay.object_version_number
1482: from per_pay_proposals pay,
1483: per_all_assignments_f paaf,
1484: per_pay_bases ppb,
1485: pay_input_values_f piv,
1486: pay_element_types_f pet
1487: where pay.assignment_id = c_assgn_id

Line 2865: per_all_assignments_f asg

2861: --
2862: cursor csr_chk_diff_in_asgn(c_item_type in varchar2, c_item_key in varchar2, c_assgn_id in number) is
2863: select trans.pay_basis_id
2864: from per_pay_transactions trans,
2865: per_all_assignments_f asg
2866: where trans.assignment_id = c_assgn_id
2867: and trans.item_type = c_item_type
2868: and trans.item_key = c_item_key
2869: and asg.assignment_id = trans.assignment_id

Line 3185: l_assignment_id per_all_assignments_f.assignment_id%type;

3181: l_inv_next_sal_date_warning boolean;
3182: l_proposed_salary_warning boolean;
3183: l_approved_warning boolean;
3184: l_payroll_warning boolean;
3185: l_assignment_id per_all_assignments_f.assignment_id%type;
3186: l_g_assignment_id per_all_assignments_f.assignment_id%type := null;
3187: --
3188: l_proc varchar2(61) := 'process_create_pay_action' ;
3189: l_item_type hr_api_transaction_steps.item_type%type;

Line 3186: l_g_assignment_id per_all_assignments_f.assignment_id%type := null;

3182: l_proposed_salary_warning boolean;
3183: l_approved_warning boolean;
3184: l_payroll_warning boolean;
3185: l_assignment_id per_all_assignments_f.assignment_id%type;
3186: l_g_assignment_id per_all_assignments_f.assignment_id%type := null;
3187: --
3188: l_proc varchar2(61) := 'process_create_pay_action' ;
3189: l_item_type hr_api_transaction_steps.item_type%type;
3190: l_item_key hr_api_transaction_steps.item_key%type;

Line 3835: from per_all_assignments_f

3831: --
3832: --
3833: Cursor csr_assgn_exists Is
3834: select '1'
3835: from per_all_assignments_f
3836: where assignment_id = p_assignment_id
3837: and p_effective_date between effective_start_date and effective_end_date;
3838: --
3839: Cursor csr_last_change_date Is

Line 3892: from per_all_assignments_f

3888: and hat.status<>'AC';
3889: --
3890: Cursor csr_future_asst_change_max(l_min_change_date date,l_change_date date) Is
3891: select effective_start_date
3892: from per_all_assignments_f
3893: where assignment_id = p_assignment_id
3894: and effective_start_date > l_min_change_date
3895: and effective_start_date < l_change_date
3896: order by effective_start_date desc;

Line 3900: from per_all_assignments_f

3896: order by effective_start_date desc;
3897: --
3898: Cursor csr_asst_start_date Is
3899: select effective_start_date
3900: from per_all_assignments_f
3901: where assignment_id = p_assignment_id
3902: order by effective_start_date asc;
3903: --
3904: Cursor csr_asst_change_date(l_max_change_date date) Is

Line 3906: from per_all_assignments_f

3902: order by effective_start_date asc;
3903: --
3904: Cursor csr_asst_change_date(l_max_change_date date) Is
3905: select effective_start_date
3906: from per_all_assignments_f
3907: where assignment_id = p_assignment_id
3908: and effective_start_date > l_max_change_date
3909: order by effective_start_date asc;
3910: --

Line 3913: from per_all_assignments_f

3909: order by effective_start_date asc;
3910: --
3911: Cursor csr_asst_basis_change_date(l_max_change_date date) Is
3912: select effective_start_date,pay_basis_id
3913: from per_all_assignments_f
3914: where assignment_id = p_assignment_id
3915: and effective_start_date > l_max_change_date
3916: and pay_basis_id <> (Select pay_basis_id from per_all_assignments_f
3917: where assignment_id = p_assignment_id

Line 3916: and pay_basis_id <> (Select pay_basis_id from per_all_assignments_f

3912: select effective_start_date,pay_basis_id
3913: from per_all_assignments_f
3914: where assignment_id = p_assignment_id
3915: and effective_start_date > l_max_change_date
3916: and pay_basis_id <> (Select pay_basis_id from per_all_assignments_f
3917: where assignment_id = p_assignment_id
3918: and l_max_change_date between effective_start_date
3919: and effective_end_date)
3920: order by effective_start_date asc;

Line 3929: ,per_all_assignments_f paaf

3925: )
3926: IS
3927: select min(ptp.start_date) next_payroll_date
3928: from per_time_periods ptp
3929: ,per_all_assignments_f paaf
3930: where ptp.payroll_id = paaf.payroll_id
3931: and paaf.assignment_id = l_assignment_id
3932: and ptp.start_date > l_date ;
3933: --

Line 3936: from per_all_assignments_f

3932: and ptp.start_date > l_date ;
3933: --
3934: Cursor csr_pay_basis_exists(c_assignment_id number, c_effective_date date) IS
3935: select pay_basis_id
3936: from per_all_assignments_f
3937: where assignment_id = c_assignment_id
3938: and c_effective_date between effective_start_date and effective_end_date;
3939: --
3940: Cursor csr_txn_basis_id Is

Line 4441: from per_all_assignments_f

4437: --
4438: --
4439: Cursor csr_pay_basis_exists(c_assignment_id number, c_effective_date date) IS
4440: select pay_basis_id
4441: from per_all_assignments_f
4442: where assignment_id = c_assignment_id
4443: and c_effective_date between effective_start_date and effective_end_date;
4444: --
4445: --

Line 4482: from per_all_assignments_f

4478: --
4479: --
4480: Cursor csr_curr_asst_change_date(l_curr_change_date date) Is
4481: select effective_start_date
4482: from per_all_assignments_f
4483: where assignment_id = p_assignment_id
4484: and effective_start_date <= l_curr_change_date
4485: order by effective_start_date desc;
4486: --

Line 4490: from per_all_assignments_f

4486: --
4487: --
4488: Cursor csr_last_asst_change_date(l_max_change_date date) Is
4489: select effective_start_date,pay_basis_id
4490: from per_all_assignments_f
4491: where assignment_id = p_assignment_id
4492: and effective_start_date > l_max_change_date
4493: order by effective_start_date asc;
4494: --

Line 4503: ,per_all_assignments_f paaf

4499: )
4500: IS
4501: select min(ptp.start_date) next_payroll_date
4502: from per_time_periods ptp
4503: ,per_all_assignments_f paaf
4504: where ptp.payroll_id = paaf.payroll_id
4505: and paaf.assignment_id = p_assignment_id
4506: and ptp.start_date > p_effective_date ;
4507: --

Line 4966: ,per_all_assignments_f paa

4962: CURSOR csr_period_table is
4963: select nvl(DESCRIPTION,ptt.period_type)
4964: from PER_TIME_PERIOD_TYPES ptt
4965: ,pay_all_payrolls_f pap
4966: ,per_all_assignments_f paa
4967: where pap.payroll_id = p_payroll_id
4968: and ptt.period_type = pap.period_type;
4969:
4970: l_period varchar2(30);

Line 5029: from per_all_assignments_f

5025: and hat.status<>'AC';
5026: --
5027: Cursor csr_future_asst_change_max(l_min_change_date date,l_change_date date) Is
5028: select effective_start_date
5029: from per_all_assignments_f
5030: where assignment_id = p_assignment_id
5031: and effective_start_date > l_min_change_date
5032: and effective_start_date < l_change_date
5033: order by effective_start_date desc;

Line 5037: from per_all_assignments_f

5033: order by effective_start_date desc;
5034: --
5035: Cursor csr_asst_change_date(l_max_change_date date) Is
5036: select effective_start_date
5037: from per_all_assignments_f
5038: where assignment_id = p_assignment_id
5039: and effective_start_date > l_max_change_date
5040: order by effective_start_date asc;
5041: --

Line 5044: from per_all_assignments_f

5040: order by effective_start_date asc;
5041: --
5042: Cursor csr_asst_basis_change_date(l_max_change_date date) Is
5043: select effective_start_date,pay_basis_id
5044: from per_all_assignments_f
5045: where assignment_id = p_assignment_id
5046: and effective_start_date > l_max_change_date
5047: and pay_basis_id <> (Select pay_basis_id from per_all_assignments_f
5048: where assignment_id = p_assignment_id

Line 5047: and pay_basis_id <> (Select pay_basis_id from per_all_assignments_f

5043: select effective_start_date,pay_basis_id
5044: from per_all_assignments_f
5045: where assignment_id = p_assignment_id
5046: and effective_start_date > l_max_change_date
5047: and pay_basis_id <> (Select pay_basis_id from per_all_assignments_f
5048: where assignment_id = p_assignment_id
5049: and l_max_change_date between effective_start_date
5050: and effective_end_date)
5051: order by effective_start_date asc;

Line 5060: ,per_all_assignments_f paaf

5056: )
5057: IS
5058: select min(ptp.start_date) next_payroll_date
5059: from per_time_periods ptp
5060: ,per_all_assignments_f paaf
5061: where ptp.payroll_id = paaf.payroll_id
5062: and paaf.assignment_id = l_assignment_id
5063: and ptp.start_date > l_date ;
5064: --

Line 5359: from per_all_assignments_f paa

5355: --changed by schowdhu for hire flow Bug#7307885 - 05-Sep-08
5356:
5357: cursor chk_asg_rec is
5358: select null
5359: from per_all_assignments_f paa
5360: where paa.assignment_id = p_assignment_id;
5361: cursor get_ids is
5362: Select max(position_id) position_id , max(org_id) org_id, max(bg_id) bg_id from (
5363: select decode (NAME, 'P_POSITION_ID', NUMBER_VALUE) position_id,