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 39: Per_all_assignments_F paa

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

Line 113: l_pay_basis per_all_assignments_f.pay_basis_id%type;

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

Line 136: from per_all_assignments_f

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

Line 284: l_asg_rec per_all_assignments_f%ROWTYPE;

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

Line 287: Select * from per_all_assignments_f

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

Line 1281: from per_all_assignments_f

1277: and hat.ITEM_KEY = p_item_key;
1278:
1279: Cursor csr_asg_basis_change_date IS
1280: select effective_start_date date_value
1281: from per_all_assignments_f
1282: where assignment_id = p_assignment_id
1283: and effective_start_date >= p_effective_date
1284: and pay_basis_id <> (Select pay_basis_id from per_all_assignments_f
1285: where assignment_id = p_assignment_id

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

1280: select effective_start_date date_value
1281: from per_all_assignments_f
1282: where assignment_id = p_assignment_id
1283: and effective_start_date >= p_effective_date
1284: and pay_basis_id <> (Select pay_basis_id from per_all_assignments_f
1285: where assignment_id = p_assignment_id
1286: and p_effective_date between effective_start_date and effective_end_date)
1287: order by date_value desc;
1288: l_date date;

Line 1471: per_all_assignments_f paaf,

1467: null PRIOR_PAY_TRANSACTION_ID,
1468: null APPROVED,
1469: pay.object_version_number
1470: from per_pay_proposals pay,
1471: per_all_assignments_f paaf,
1472: per_pay_bases ppb,
1473: pay_input_values_f piv,
1474: pay_element_types_f pet
1475: where pay.assignment_id = c_assgn_id

Line 2834: per_all_assignments_f asg

2830: --
2831: cursor csr_chk_diff_in_asgn(c_item_type in varchar2, c_item_key in varchar2, c_assgn_id in number) is
2832: select trans.pay_basis_id
2833: from per_pay_transactions trans,
2834: per_all_assignments_f asg
2835: where trans.assignment_id = c_assgn_id
2836: and trans.item_type = c_item_type
2837: and trans.item_key = c_item_key
2838: and asg.assignment_id = trans.assignment_id

Line 3160: l_assignment_id per_all_assignments_f.assignment_id%type;

3156: l_inv_next_sal_date_warning boolean;
3157: l_proposed_salary_warning boolean;
3158: l_approved_warning boolean;
3159: l_payroll_warning boolean;
3160: l_assignment_id per_all_assignments_f.assignment_id%type;
3161: l_g_assignment_id per_all_assignments_f.assignment_id%type := null;
3162: --
3163: l_proc varchar2(61) := 'process_create_pay_action' ;
3164: l_item_type hr_api_transaction_steps.item_type%type;

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

3157: l_proposed_salary_warning boolean;
3158: l_approved_warning boolean;
3159: l_payroll_warning boolean;
3160: l_assignment_id per_all_assignments_f.assignment_id%type;
3161: l_g_assignment_id per_all_assignments_f.assignment_id%type := null;
3162: --
3163: l_proc varchar2(61) := 'process_create_pay_action' ;
3164: l_item_type hr_api_transaction_steps.item_type%type;
3165: l_item_key hr_api_transaction_steps.item_key%type;

Line 3715: from per_all_assignments_f

3711: --
3712: --
3713: Cursor csr_assgn_exists Is
3714: select '1'
3715: from per_all_assignments_f
3716: where assignment_id = p_assignment_id
3717: and p_effective_date between effective_start_date and effective_end_date;
3718: --
3719: Cursor csr_last_change_date Is

Line 3761: from per_all_assignments_f

3757: and hat.TRANSACTION_ID = p_transaction_id;
3758: --
3759: Cursor csr_future_asst_change_max(l_min_change_date date,l_change_date date) Is
3760: select effective_start_date
3761: from per_all_assignments_f
3762: where assignment_id = p_assignment_id
3763: and effective_start_date > l_min_change_date
3764: and effective_start_date < l_change_date
3765: order by effective_start_date desc;

Line 3769: from per_all_assignments_f

3765: order by effective_start_date desc;
3766: --
3767: Cursor csr_asst_start_date Is
3768: select effective_start_date
3769: from per_all_assignments_f
3770: where assignment_id = p_assignment_id
3771: order by effective_start_date asc;
3772: --
3773: Cursor csr_asst_change_date(l_max_change_date date) Is

Line 3775: from per_all_assignments_f

3771: order by effective_start_date asc;
3772: --
3773: Cursor csr_asst_change_date(l_max_change_date date) Is
3774: select effective_start_date
3775: from per_all_assignments_f
3776: where assignment_id = p_assignment_id
3777: and effective_start_date > l_max_change_date
3778: order by effective_start_date asc;
3779: --

Line 3782: from per_all_assignments_f

3778: order by effective_start_date asc;
3779: --
3780: Cursor csr_asst_basis_change_date(l_max_change_date date) Is
3781: select effective_start_date,pay_basis_id
3782: from per_all_assignments_f
3783: where assignment_id = p_assignment_id
3784: and effective_start_date > l_max_change_date
3785: and pay_basis_id <> (Select pay_basis_id from per_all_assignments_f
3786: where assignment_id = p_assignment_id

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

3781: select effective_start_date,pay_basis_id
3782: from per_all_assignments_f
3783: where assignment_id = p_assignment_id
3784: and effective_start_date > l_max_change_date
3785: and pay_basis_id <> (Select pay_basis_id from per_all_assignments_f
3786: where assignment_id = p_assignment_id
3787: and l_max_change_date between effective_start_date
3788: and effective_end_date)
3789: order by effective_start_date asc;

Line 3798: ,per_all_assignments_f paaf

3794: )
3795: IS
3796: select min(ptp.start_date) next_payroll_date
3797: from per_time_periods ptp
3798: ,per_all_assignments_f paaf
3799: where ptp.payroll_id = paaf.payroll_id
3800: and paaf.assignment_id = l_assignment_id
3801: and ptp.start_date > l_date ;
3802: --

Line 3805: from per_all_assignments_f

3801: and ptp.start_date > l_date ;
3802: --
3803: Cursor csr_pay_basis_exists(c_assignment_id number, c_effective_date date) IS
3804: select pay_basis_id
3805: from per_all_assignments_f
3806: where assignment_id = c_assignment_id
3807: and c_effective_date between effective_start_date and effective_end_date;
3808: --
3809: Cursor csr_txn_basis_id Is

Line 4309: from per_all_assignments_f

4305: --
4306: --
4307: Cursor csr_pay_basis_exists(c_assignment_id number, c_effective_date date) IS
4308: select pay_basis_id
4309: from per_all_assignments_f
4310: where assignment_id = c_assignment_id
4311: and c_effective_date between effective_start_date and effective_end_date;
4312: --
4313: --

Line 4346: from per_all_assignments_f

4342: --
4343: --
4344: Cursor csr_curr_asst_change_date(l_curr_change_date date) Is
4345: select effective_start_date
4346: from per_all_assignments_f
4347: where assignment_id = p_assignment_id
4348: and effective_start_date <= l_curr_change_date
4349: order by effective_start_date desc;
4350: --

Line 4354: from per_all_assignments_f

4350: --
4351: --
4352: Cursor csr_last_asst_change_date(l_max_change_date date) Is
4353: select effective_start_date,pay_basis_id
4354: from per_all_assignments_f
4355: where assignment_id = p_assignment_id
4356: and effective_start_date > l_max_change_date
4357: order by effective_start_date asc;
4358: --

Line 4367: ,per_all_assignments_f paaf

4363: )
4364: IS
4365: select min(ptp.start_date) next_payroll_date
4366: from per_time_periods ptp
4367: ,per_all_assignments_f paaf
4368: where ptp.payroll_id = paaf.payroll_id
4369: and paaf.assignment_id = p_assignment_id
4370: and ptp.start_date > p_effective_date ;
4371: --

Line 4830: ,per_all_assignments_f paa

4826: CURSOR csr_period_table is
4827: select nvl(DESCRIPTION,ptt.period_type)
4828: from PER_TIME_PERIOD_TYPES ptt
4829: ,pay_all_payrolls_f pap
4830: ,per_all_assignments_f paa
4831: where pap.payroll_id = p_payroll_id
4832: and ptt.period_type = pap.period_type;
4833:
4834: l_period varchar2(30);

Line 4891: from per_all_assignments_f

4887: and hat.TRANSACTION_ID = p_transaction_id;
4888: --
4889: Cursor csr_future_asst_change_max(l_min_change_date date,l_change_date date) Is
4890: select effective_start_date
4891: from per_all_assignments_f
4892: where assignment_id = p_assignment_id
4893: and effective_start_date > l_min_change_date
4894: and effective_start_date < l_change_date
4895: order by effective_start_date desc;

Line 4899: from per_all_assignments_f

4895: order by effective_start_date desc;
4896: --
4897: Cursor csr_asst_change_date(l_max_change_date date) Is
4898: select effective_start_date
4899: from per_all_assignments_f
4900: where assignment_id = p_assignment_id
4901: and effective_start_date > l_max_change_date
4902: order by effective_start_date asc;
4903: --

Line 4906: from per_all_assignments_f

4902: order by effective_start_date asc;
4903: --
4904: Cursor csr_asst_basis_change_date(l_max_change_date date) Is
4905: select effective_start_date,pay_basis_id
4906: from per_all_assignments_f
4907: where assignment_id = p_assignment_id
4908: and effective_start_date > l_max_change_date
4909: and pay_basis_id <> (Select pay_basis_id from per_all_assignments_f
4910: where assignment_id = p_assignment_id

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

4905: select effective_start_date,pay_basis_id
4906: from per_all_assignments_f
4907: where assignment_id = p_assignment_id
4908: and effective_start_date > l_max_change_date
4909: and pay_basis_id <> (Select pay_basis_id from per_all_assignments_f
4910: where assignment_id = p_assignment_id
4911: and l_max_change_date between effective_start_date
4912: and effective_end_date)
4913: order by effective_start_date asc;

Line 4922: ,per_all_assignments_f paaf

4918: )
4919: IS
4920: select min(ptp.start_date) next_payroll_date
4921: from per_time_periods ptp
4922: ,per_all_assignments_f paaf
4923: where ptp.payroll_id = paaf.payroll_id
4924: and paaf.assignment_id = l_assignment_id
4925: and ptp.start_date > l_date ;
4926: --

Line 5218: from per_all_assignments_f paa

5214: --changed by schowdhu for hire flow Bug#7307885 - 05-Sep-08
5215:
5216: cursor chk_asg_rec is
5217: select null
5218: from per_all_assignments_f paa
5219: where paa.assignment_id = p_assignment_id;
5220: cursor get_ids is
5221: Select max(position_id) position_id , max(org_id) org_id, max(bg_id) bg_id from (
5222: select decode (NAME, 'P_POSITION_ID', NUMBER_VALUE) position_id,