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 42: from per_assignments_f paf,

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

Line 93: l_assignment_id per_assignments_f.assignment_id%type;

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

Line 94: l_position_id per_assignments_f.position_id%type;

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

Line 95: l_grade_id per_assignments_f.grade_id%type;

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

Line 96: l_business_group_id per_assignments_f.business_group_id%type;

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

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

1127: p_action IN varchar2) is
1128:
1129: p_mass_salary varchar2(32);
1130: --
1131: -- Main Cursor which fetches from per_assignments_f and per_people_f
1132: --
1133: -- 1. Cursor with organization.
1134: --
1135: cursor cur_people_org (effective_date date, p_org_id number) is

Line 1153: from per_assignments_f paf,

1149: paf.location_id LOCATION_ID,
1150: paf.organization_id ORGANIZATION_ID,
1151: paf.business_group_id BUSINESS_GROUP_ID,
1152: paf.assignment_status_type_id ASSIGNMENT_STATUS_TYPE_ID
1153: from per_assignments_f paf,
1154: per_people_f ppf,
1155: per_person_types ppt
1156: where ppf.person_id = paf.person_id
1157: and effective_date between ppf.effective_start_date and ppf.effective_end_date

Line 1189: from per_assignments_f paf,

1185: paf.location_id LOCATION_ID,
1186: paf.organization_id ORGANIZATION_ID,
1187: paf.business_group_id BUSINESS_GROUP_ID,
1188: paf.assignment_status_type_id ASSIGNMENT_STATUS_TYPE_ID
1189: from per_assignments_f paf,
1190: per_people_f ppf,
1191: per_person_types ppt
1192: where ppf.person_id = paf.person_id
1193: and effective_date between ppf.effective_start_date and ppf.effective_end_date

Line 1275: FROM per_people_f p, per_assignments_f a

1271: and pop.organization_id = nvl(p_org_pos_id,pop.organization_id)
1272: and not exists
1273: (
1274: SELECT 'X'
1275: FROM per_people_f p, per_assignments_f a
1276: WHERE trunc(effective_DATE) between a.effective_start_DATE and a.effective_END_DATE
1277: AND a.primary_flag = 'Y'
1278: AND a.assignment_type <> 'B'
1279: AND p.current_employee_flag = 'Y'

Line 1295: l_assignment_id per_assignments_f.assignment_id%type;

1291:
1292: l_pos_name hr_positions_f.name%type;
1293: ----Bug 4699955
1294:
1295: l_assignment_id per_assignments_f.assignment_id%type;
1296: l_position_id per_assignments_f.position_id%type;
1297: l_grade_id per_assignments_f.grade_id%type;
1298: l_business_group_id per_assignments_f.business_group_id%type;
1299:

Line 1296: l_position_id per_assignments_f.position_id%type;

1292: l_pos_name hr_positions_f.name%type;
1293: ----Bug 4699955
1294:
1295: l_assignment_id per_assignments_f.assignment_id%type;
1296: l_position_id per_assignments_f.position_id%type;
1297: l_grade_id per_assignments_f.grade_id%type;
1298: l_business_group_id per_assignments_f.business_group_id%type;
1299:
1300: l_position_title varchar2(300);

Line 1297: l_grade_id per_assignments_f.grade_id%type;

1293: ----Bug 4699955
1294:
1295: l_assignment_id per_assignments_f.assignment_id%type;
1296: l_position_id per_assignments_f.position_id%type;
1297: l_grade_id per_assignments_f.grade_id%type;
1298: l_business_group_id per_assignments_f.business_group_id%type;
1299:
1300: l_position_title varchar2(300);
1301: l_position_number varchar2(20);

Line 1298: l_business_group_id per_assignments_f.business_group_id%type;

1294:
1295: l_assignment_id per_assignments_f.assignment_id%type;
1296: l_position_id per_assignments_f.position_id%type;
1297: l_grade_id per_assignments_f.grade_id%type;
1298: l_business_group_id per_assignments_f.business_group_id%type;
1299:
1300: l_position_title varchar2(300);
1301: l_position_number varchar2(20);
1302: l_position_seq_no varchar2(20);

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

1492: where substr(user_table_name,1,4) = pay_table;
1493:
1494:
1495:
1496: PROCEDURE msl_pay_process(p_assignment_id per_assignments_f.assignment_id%TYPE
1497: ,p_person_id per_assignments_f.person_id%TYPE
1498: ,p_position_id per_assignments_f.position_id%TYPE
1499: ,p_grade_id per_assignments_f.grade_id%TYPE
1500: ,p_business_group_id per_assignments_f.business_group_iD%TYPE

Line 1497: ,p_person_id per_assignments_f.person_id%TYPE

1493:
1494:
1495:
1496: PROCEDURE msl_pay_process(p_assignment_id per_assignments_f.assignment_id%TYPE
1497: ,p_person_id per_assignments_f.person_id%TYPE
1498: ,p_position_id per_assignments_f.position_id%TYPE
1499: ,p_grade_id per_assignments_f.grade_id%TYPE
1500: ,p_business_group_id per_assignments_f.business_group_iD%TYPE
1501: ,p_location_id per_assignments_f.location_id%TYPE

Line 1498: ,p_position_id per_assignments_f.position_id%TYPE

1494:
1495:
1496: PROCEDURE msl_pay_process(p_assignment_id per_assignments_f.assignment_id%TYPE
1497: ,p_person_id per_assignments_f.person_id%TYPE
1498: ,p_position_id per_assignments_f.position_id%TYPE
1499: ,p_grade_id per_assignments_f.grade_id%TYPE
1500: ,p_business_group_id per_assignments_f.business_group_iD%TYPE
1501: ,p_location_id per_assignments_f.location_id%TYPE
1502: ,p_organization_id per_assignments_f.organization_id%TYPE

Line 1499: ,p_grade_id per_assignments_f.grade_id%TYPE

1495:
1496: PROCEDURE msl_pay_process(p_assignment_id per_assignments_f.assignment_id%TYPE
1497: ,p_person_id per_assignments_f.person_id%TYPE
1498: ,p_position_id per_assignments_f.position_id%TYPE
1499: ,p_grade_id per_assignments_f.grade_id%TYPE
1500: ,p_business_group_id per_assignments_f.business_group_iD%TYPE
1501: ,p_location_id per_assignments_f.location_id%TYPE
1502: ,p_organization_id per_assignments_f.organization_id%TYPE
1503: ,p_date_of_birth date

Line 1500: ,p_business_group_id per_assignments_f.business_group_iD%TYPE

1496: PROCEDURE msl_pay_process(p_assignment_id per_assignments_f.assignment_id%TYPE
1497: ,p_person_id per_assignments_f.person_id%TYPE
1498: ,p_position_id per_assignments_f.position_id%TYPE
1499: ,p_grade_id per_assignments_f.grade_id%TYPE
1500: ,p_business_group_id per_assignments_f.business_group_iD%TYPE
1501: ,p_location_id per_assignments_f.location_id%TYPE
1502: ,p_organization_id per_assignments_f.organization_id%TYPE
1503: ,p_date_of_birth date
1504: ,p_first_name per_people_f.first_name%TYPE

Line 1501: ,p_location_id per_assignments_f.location_id%TYPE

1497: ,p_person_id per_assignments_f.person_id%TYPE
1498: ,p_position_id per_assignments_f.position_id%TYPE
1499: ,p_grade_id per_assignments_f.grade_id%TYPE
1500: ,p_business_group_id per_assignments_f.business_group_iD%TYPE
1501: ,p_location_id per_assignments_f.location_id%TYPE
1502: ,p_organization_id per_assignments_f.organization_id%TYPE
1503: ,p_date_of_birth date
1504: ,p_first_name per_people_f.first_name%TYPE
1505: ,p_last_name per_people_f.last_name%TYPE

Line 1502: ,p_organization_id per_assignments_f.organization_id%TYPE

1498: ,p_position_id per_assignments_f.position_id%TYPE
1499: ,p_grade_id per_assignments_f.grade_id%TYPE
1500: ,p_business_group_id per_assignments_f.business_group_iD%TYPE
1501: ,p_location_id per_assignments_f.location_id%TYPE
1502: ,p_organization_id per_assignments_f.organization_id%TYPE
1503: ,p_date_of_birth date
1504: ,p_first_name per_people_f.first_name%TYPE
1505: ,p_last_name per_people_f.last_name%TYPE
1506: ,p_full_name per_people_f.full_name%TYPE

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

3885: --
3886: --
3887: --
3888:
3889: procedure get_pos_grp1_ddf (p_position_id in per_assignments_f.position_id%type,
3890: p_effective_date in date,
3891: p_pos_ei_data out nocopy per_position_extra_info%rowtype)
3892: IS
3893:

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

4199: --
4200: --
4201:
4202: procedure get_sub_element_code_pos_title
4203: (p_position_id in per_assignments_f.position_id%type,
4204: p_person_id in number,
4205: p_business_group_id in per_assignments_f.business_group_id%type,
4206: p_assignment_id in per_assignments_f.assignment_id%type,
4207: p_effective_date in date,

Line 4205: p_business_group_id in per_assignments_f.business_group_id%type,

4201:
4202: procedure get_sub_element_code_pos_title
4203: (p_position_id in per_assignments_f.position_id%type,
4204: p_person_id in number,
4205: p_business_group_id in per_assignments_f.business_group_id%type,
4206: p_assignment_id in per_assignments_f.assignment_id%type,
4207: p_effective_date in date,
4208: p_sub_element_code out nocopy varchar2,
4209: p_position_title out nocopy varchar2,

Line 4206: p_assignment_id in per_assignments_f.assignment_id%type,

4202: procedure get_sub_element_code_pos_title
4203: (p_position_id in per_assignments_f.position_id%type,
4204: p_person_id in number,
4205: p_business_group_id in per_assignments_f.business_group_id%type,
4206: p_assignment_id in per_assignments_f.assignment_id%type,
4207: p_effective_date in date,
4208: p_sub_element_code out nocopy varchar2,
4209: p_position_title out nocopy varchar2,
4210: p_position_number out nocopy varchar2,

Line 4318: p_position_id in per_assignments_f.position_id%type,

4314: p_tot_old_sal in number,
4315: p_tot_new_sal in number,
4316: p_old_auo_pay in number,
4317: p_new_auo_pay in number,
4318: p_position_id in per_assignments_f.position_id%type,
4319: p_position_title in varchar2,
4320: -- FWFA Changes Bug#4444609
4321: p_position_number in varchar2,
4322: p_position_seq_no in varchar2,

Line 4641: p_position_id in per_assignments_f.position_id%type,

4637: p_tot_old_sal in number,
4638: p_tot_new_sal in number,
4639: p_old_auo_pay in number,
4640: p_new_auo_pay in number,
4641: p_position_id in per_assignments_f.position_id%type,
4642: p_position_title in varchar2,
4643: -- FWFA Changes Bug#4444609
4644: p_position_number in varchar2,
4645: p_position_seq_no in varchar2,

Line 5465: l_position_id per_assignments_f.position_id%type;

5461: between pos.effective_start_date and pos.effective_end_date
5462: AND HR_GENERAL.DECODE_AVAILABILITY_STATUS(pos.availability_status_id) = 'Active');
5463:
5464: l_hist_id ghr_pa_history.pa_history_id%type;
5465: l_position_id per_assignments_f.position_id%type;
5466: l_his_eff_date ghr_pa_requests.effective_date%type;
5467: l_user_tab_id pay_user_tables.user_table_id%type;
5468:
5469: