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.GHR_MLC_PKG dependencies on PER_ASSIGNMENTS_F

Line 21: -- Main Cursor which fetches from per_assignments_f and per_people_f

17: p_mass_salary varchar2(32);
18: l_p_locality_area_code ghr_mass_salaries.locality_pay_area_code%type;
19:
20: --
21: -- Main Cursor which fetches from per_assignments_f and per_people_f
22: --
23: -- Bug 4377361 included EMP_APL for person type condition
24:
25: cursor cur_people (effective_date date, p_org_id number) is

Line 40: from per_assignments_f paf,

36: paf.job_id JOB_ID,
37: paf.location_id LOCATION_ID,
38: paf.organization_id ORGANIZATION_ID,
39: paf.business_group_id BUSINESS_GROUP_ID
40: from per_assignments_f paf,
41: per_people_f ppf,
42: per_person_types ppt,
43: per_assignment_status_types pas_t,
44: hr_location_extra_info hlei,

Line 91: l_assignment_id per_assignments_f.assignment_id%type;

87: FROM ghr_nature_of_actions
88: WHERE code = nvl(ghr_msl_pkg.g_first_noa_code,'895') )
89: ) and proc_method_flag = 'Y';
90:
91: l_assignment_id per_assignments_f.assignment_id%type;
92: l_position_id per_assignments_f.position_id%type;
93: l_grade_id per_assignments_f.grade_id%type;
94: l_business_group_id per_assignments_f.business_group_id%type;
95:

Line 92: l_position_id per_assignments_f.position_id%type;

88: WHERE code = nvl(ghr_msl_pkg.g_first_noa_code,'895') )
89: ) and proc_method_flag = 'Y';
90:
91: l_assignment_id per_assignments_f.assignment_id%type;
92: l_position_id per_assignments_f.position_id%type;
93: l_grade_id per_assignments_f.grade_id%type;
94: l_business_group_id per_assignments_f.business_group_id%type;
95:
96: l_position_title varchar2(300);

Line 93: l_grade_id per_assignments_f.grade_id%type;

89: ) and proc_method_flag = 'Y';
90:
91: l_assignment_id per_assignments_f.assignment_id%type;
92: l_position_id per_assignments_f.position_id%type;
93: l_grade_id per_assignments_f.grade_id%type;
94: l_business_group_id per_assignments_f.business_group_id%type;
95:
96: l_position_title varchar2(300);
97: l_position_number varchar2(20);

Line 94: l_business_group_id per_assignments_f.business_group_id%type;

90:
91: l_assignment_id per_assignments_f.assignment_id%type;
92: l_position_id per_assignments_f.position_id%type;
93: l_grade_id per_assignments_f.grade_id%type;
94: l_business_group_id per_assignments_f.business_group_id%type;
95:
96: l_position_title varchar2(300);
97: l_position_number varchar2(20);
98: l_position_seq_no varchar2(20);

Line 1111: -- Main Cursor which fetches from per_assignments_f and per_people_f

1107: p_action IN varchar2) is
1108:
1109: p_mass_salary varchar2(32);
1110: --
1111: -- Main Cursor which fetches from per_assignments_f and per_people_f
1112: --
1113: -- 1. Cursor with organization.
1114: --
1115: cursor cur_people_org (effective_date date, p_org_id number) is

Line 1131: from per_assignments_f paf,

1127: paf.location_id LOCATION_ID,
1128: paf.organization_id ORGANIZATION_ID,
1129: paf.business_group_id BUSINESS_GROUP_ID,
1130: paf.assignment_status_type_id ASSIGNMENT_STATUS_TYPE_ID
1131: from per_assignments_f paf,
1132: per_people_f ppf,
1133: per_person_types ppt
1134: where ppf.person_id = paf.person_id
1135: and effective_date between ppf.effective_start_date and ppf.effective_end_date

Line 1165: from per_assignments_f paf,

1161: paf.location_id LOCATION_ID,
1162: paf.organization_id ORGANIZATION_ID,
1163: paf.business_group_id BUSINESS_GROUP_ID,
1164: paf.assignment_status_type_id ASSIGNMENT_STATUS_TYPE_ID
1165: from per_assignments_f paf,
1166: per_people_f ppf,
1167: per_person_types ppt
1168: where ppf.person_id = paf.person_id
1169: and effective_date between ppf.effective_start_date and ppf.effective_end_date

Line 1249: FROM per_people_f p, per_assignments_f a

1245: and pop.organization_id = nvl(p_org_pos_id,pop.organization_id)
1246: and not exists
1247: (
1248: SELECT 'X'
1249: FROM per_people_f p, per_assignments_f a
1250: WHERE trunc(effective_DATE) between a.effective_start_DATE and a.effective_END_DATE
1251: AND a.primary_flag = 'Y'
1252: AND a.assignment_type <> 'B'
1253: AND p.current_employee_flag = 'Y'

Line 1269: l_assignment_id per_assignments_f.assignment_id%type;

1265:
1266: l_pos_name hr_positions_f.name%type;
1267: ----Bug 4699955
1268:
1269: l_assignment_id per_assignments_f.assignment_id%type;
1270: l_position_id per_assignments_f.position_id%type;
1271: l_grade_id per_assignments_f.grade_id%type;
1272: l_business_group_id per_assignments_f.business_group_id%type;
1273:

Line 1270: l_position_id per_assignments_f.position_id%type;

1266: l_pos_name hr_positions_f.name%type;
1267: ----Bug 4699955
1268:
1269: l_assignment_id per_assignments_f.assignment_id%type;
1270: l_position_id per_assignments_f.position_id%type;
1271: l_grade_id per_assignments_f.grade_id%type;
1272: l_business_group_id per_assignments_f.business_group_id%type;
1273:
1274: l_position_title varchar2(300);

Line 1271: l_grade_id per_assignments_f.grade_id%type;

1267: ----Bug 4699955
1268:
1269: l_assignment_id per_assignments_f.assignment_id%type;
1270: l_position_id per_assignments_f.position_id%type;
1271: l_grade_id per_assignments_f.grade_id%type;
1272: l_business_group_id per_assignments_f.business_group_id%type;
1273:
1274: l_position_title varchar2(300);
1275: l_position_number varchar2(20);

Line 1272: l_business_group_id per_assignments_f.business_group_id%type;

1268:
1269: l_assignment_id per_assignments_f.assignment_id%type;
1270: l_position_id per_assignments_f.position_id%type;
1271: l_grade_id per_assignments_f.grade_id%type;
1272: l_business_group_id per_assignments_f.business_group_id%type;
1273:
1274: l_position_title varchar2(300);
1275: l_position_number varchar2(20);
1276: l_position_seq_no varchar2(20);

Line 1470: PROCEDURE msl_pay_process(p_assignment_id per_assignments_f.assignment_id%TYPE

1466: where substr(user_table_name,1,4) = pay_table;
1467:
1468:
1469:
1470: PROCEDURE msl_pay_process(p_assignment_id per_assignments_f.assignment_id%TYPE
1471: ,p_person_id per_assignments_f.person_id%TYPE
1472: ,p_position_id per_assignments_f.position_id%TYPE
1473: ,p_grade_id per_assignments_f.grade_id%TYPE
1474: ,p_business_group_id per_assignments_f.business_group_iD%TYPE

Line 1471: ,p_person_id per_assignments_f.person_id%TYPE

1467:
1468:
1469:
1470: PROCEDURE msl_pay_process(p_assignment_id per_assignments_f.assignment_id%TYPE
1471: ,p_person_id per_assignments_f.person_id%TYPE
1472: ,p_position_id per_assignments_f.position_id%TYPE
1473: ,p_grade_id per_assignments_f.grade_id%TYPE
1474: ,p_business_group_id per_assignments_f.business_group_iD%TYPE
1475: ,p_location_id per_assignments_f.location_id%TYPE

Line 1472: ,p_position_id per_assignments_f.position_id%TYPE

1468:
1469:
1470: PROCEDURE msl_pay_process(p_assignment_id per_assignments_f.assignment_id%TYPE
1471: ,p_person_id per_assignments_f.person_id%TYPE
1472: ,p_position_id per_assignments_f.position_id%TYPE
1473: ,p_grade_id per_assignments_f.grade_id%TYPE
1474: ,p_business_group_id per_assignments_f.business_group_iD%TYPE
1475: ,p_location_id per_assignments_f.location_id%TYPE
1476: ,p_organization_id per_assignments_f.organization_id%TYPE

Line 1473: ,p_grade_id per_assignments_f.grade_id%TYPE

1469:
1470: PROCEDURE msl_pay_process(p_assignment_id per_assignments_f.assignment_id%TYPE
1471: ,p_person_id per_assignments_f.person_id%TYPE
1472: ,p_position_id per_assignments_f.position_id%TYPE
1473: ,p_grade_id per_assignments_f.grade_id%TYPE
1474: ,p_business_group_id per_assignments_f.business_group_iD%TYPE
1475: ,p_location_id per_assignments_f.location_id%TYPE
1476: ,p_organization_id per_assignments_f.organization_id%TYPE
1477: ,p_date_of_birth date

Line 1474: ,p_business_group_id per_assignments_f.business_group_iD%TYPE

1470: PROCEDURE msl_pay_process(p_assignment_id per_assignments_f.assignment_id%TYPE
1471: ,p_person_id per_assignments_f.person_id%TYPE
1472: ,p_position_id per_assignments_f.position_id%TYPE
1473: ,p_grade_id per_assignments_f.grade_id%TYPE
1474: ,p_business_group_id per_assignments_f.business_group_iD%TYPE
1475: ,p_location_id per_assignments_f.location_id%TYPE
1476: ,p_organization_id per_assignments_f.organization_id%TYPE
1477: ,p_date_of_birth date
1478: ,p_first_name per_people_f.first_name%TYPE

Line 1475: ,p_location_id per_assignments_f.location_id%TYPE

1471: ,p_person_id per_assignments_f.person_id%TYPE
1472: ,p_position_id per_assignments_f.position_id%TYPE
1473: ,p_grade_id per_assignments_f.grade_id%TYPE
1474: ,p_business_group_id per_assignments_f.business_group_iD%TYPE
1475: ,p_location_id per_assignments_f.location_id%TYPE
1476: ,p_organization_id per_assignments_f.organization_id%TYPE
1477: ,p_date_of_birth date
1478: ,p_first_name per_people_f.first_name%TYPE
1479: ,p_last_name per_people_f.last_name%TYPE

Line 1476: ,p_organization_id per_assignments_f.organization_id%TYPE

1472: ,p_position_id per_assignments_f.position_id%TYPE
1473: ,p_grade_id per_assignments_f.grade_id%TYPE
1474: ,p_business_group_id per_assignments_f.business_group_iD%TYPE
1475: ,p_location_id per_assignments_f.location_id%TYPE
1476: ,p_organization_id per_assignments_f.organization_id%TYPE
1477: ,p_date_of_birth date
1478: ,p_first_name per_people_f.first_name%TYPE
1479: ,p_last_name per_people_f.last_name%TYPE
1480: ,p_full_name per_people_f.full_name%TYPE

Line 3843: procedure get_pos_grp1_ddf (p_position_id in per_assignments_f.position_id%type,

3839: --
3840: --
3841: --
3842:
3843: procedure get_pos_grp1_ddf (p_position_id in per_assignments_f.position_id%type,
3844: p_effective_date in date,
3845: p_pos_ei_data out nocopy per_position_extra_info%rowtype)
3846: IS
3847:

Line 4157: (p_position_id in per_assignments_f.position_id%type,

4153: --
4154: --
4155:
4156: procedure get_sub_element_code_pos_title
4157: (p_position_id in per_assignments_f.position_id%type,
4158: p_person_id in number,
4159: p_business_group_id in per_assignments_f.business_group_id%type,
4160: p_assignment_id in per_assignments_f.assignment_id%type,
4161: p_effective_date in date,

Line 4159: p_business_group_id in per_assignments_f.business_group_id%type,

4155:
4156: procedure get_sub_element_code_pos_title
4157: (p_position_id in per_assignments_f.position_id%type,
4158: p_person_id in number,
4159: p_business_group_id in per_assignments_f.business_group_id%type,
4160: p_assignment_id in per_assignments_f.assignment_id%type,
4161: p_effective_date in date,
4162: p_sub_element_code out nocopy varchar2,
4163: p_position_title out nocopy varchar2,

Line 4160: p_assignment_id in per_assignments_f.assignment_id%type,

4156: procedure get_sub_element_code_pos_title
4157: (p_position_id in per_assignments_f.position_id%type,
4158: p_person_id in number,
4159: p_business_group_id in per_assignments_f.business_group_id%type,
4160: p_assignment_id in per_assignments_f.assignment_id%type,
4161: p_effective_date in date,
4162: p_sub_element_code out nocopy varchar2,
4163: p_position_title out nocopy varchar2,
4164: p_position_number out nocopy varchar2,

Line 4270: p_position_id in per_assignments_f.position_id%type,

4266: p_tot_old_sal in number,
4267: p_tot_new_sal in number,
4268: p_old_auo_pay in number,
4269: p_new_auo_pay in number,
4270: p_position_id in per_assignments_f.position_id%type,
4271: p_position_title in varchar2,
4272: -- FWFA Changes Bug#4444609
4273: p_position_number in varchar2,
4274: p_position_seq_no in varchar2,

Line 4587: p_position_id in per_assignments_f.position_id%type,

4583: p_tot_old_sal in number,
4584: p_tot_new_sal in number,
4585: p_old_auo_pay in number,
4586: p_new_auo_pay in number,
4587: p_position_id in per_assignments_f.position_id%type,
4588: p_position_title in varchar2,
4589: -- FWFA Changes Bug#4444609
4590: p_position_number in varchar2,
4591: p_position_seq_no in varchar2,

Line 5407: l_position_id per_assignments_f.position_id%type;

5403: between pos.effective_start_date and pos.effective_end_date
5404: AND HR_GENERAL.DECODE_AVAILABILITY_STATUS(pos.availability_status_id) = 'Active');
5405:
5406: l_hist_id ghr_pa_history.pa_history_id%type;
5407: l_position_id per_assignments_f.position_id%type;
5408: l_his_eff_date ghr_pa_requests.effective_date%type;
5409: l_user_tab_id pay_user_tables.user_table_id%type;
5410:
5411: