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

Line 58: ,p_assignment_rec out nocopy per_all_assignments_f%rowtype) is

54:
55: -- bug 5032032
56: procedure get_asg_from_tt
57: (p_transaction_step_id in number
58: ,p_assignment_rec out nocopy per_all_assignments_f%rowtype) is
59: l_proc varchar2(72) := g_package||'get_asg_from_tt';
60:
61: begin
62: --dbms_output.put_line(' ');

Line 2238: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

2234: ,p_vendor_site_id in number default hr_api.g_number
2235: ,p_proj_asgn_end in date default g_canonical_date
2236:
2237: ) is
2238: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
2239: l_person_id per_all_assignments_f.person_id%TYPE;
2240: l_item_type hr_api_transaction_steps.item_type%TYPE;
2241: l_item_key hr_api_transaction_steps.item_key%TYPE;
2242: l_activity_id hr_api_transaction_steps.activity_id%TYPE;

Line 2239: l_person_id per_all_assignments_f.person_id%TYPE;

2235: ,p_proj_asgn_end in date default g_canonical_date
2236:
2237: ) is
2238: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
2239: l_person_id per_all_assignments_f.person_id%TYPE;
2240: l_item_type hr_api_transaction_steps.item_type%TYPE;
2241: l_item_key hr_api_transaction_steps.item_key%TYPE;
2242: l_activity_id hr_api_transaction_steps.activity_id%TYPE;
2243: l_effective_date date;

Line 2251: l_assignment_rec per_all_assignments_f%rowtype;

2247: l_result varchar2(100);
2248: l_transaction_step_id number;
2249: l_count number;
2250: l_trans_tbl hr_transaction_ss.transaction_table;
2251: l_assignment_rec per_all_assignments_f%rowtype;
2252: l_old_assignment_rec per_all_assignments_f%rowtype;
2253: l_db_assignment_rec per_all_assignments_f%rowtype;
2254: l_date_error boolean default false;
2255: l_special_ceiling_step_id per_all_assignments_f.special_ceiling_step_id%TYPE;

Line 2252: l_old_assignment_rec per_all_assignments_f%rowtype;

2248: l_transaction_step_id number;
2249: l_count number;
2250: l_trans_tbl hr_transaction_ss.transaction_table;
2251: l_assignment_rec per_all_assignments_f%rowtype;
2252: l_old_assignment_rec per_all_assignments_f%rowtype;
2253: l_db_assignment_rec per_all_assignments_f%rowtype;
2254: l_date_error boolean default false;
2255: l_special_ceiling_step_id per_all_assignments_f.special_ceiling_step_id%TYPE;
2256: l_trns_object_version_number number;

Line 2253: l_db_assignment_rec per_all_assignments_f%rowtype;

2249: l_count number;
2250: l_trans_tbl hr_transaction_ss.transaction_table;
2251: l_assignment_rec per_all_assignments_f%rowtype;
2252: l_old_assignment_rec per_all_assignments_f%rowtype;
2253: l_db_assignment_rec per_all_assignments_f%rowtype;
2254: l_date_error boolean default false;
2255: l_special_ceiling_step_id per_all_assignments_f.special_ceiling_step_id%TYPE;
2256: l_trns_object_version_number number;
2257: l_datetrack_update_mode varchar2(30);

Line 2255: l_special_ceiling_step_id per_all_assignments_f.special_ceiling_step_id%TYPE;

2251: l_assignment_rec per_all_assignments_f%rowtype;
2252: l_old_assignment_rec per_all_assignments_f%rowtype;
2253: l_db_assignment_rec per_all_assignments_f%rowtype;
2254: l_date_error boolean default false;
2255: l_special_ceiling_step_id per_all_assignments_f.special_ceiling_step_id%TYPE;
2256: l_trns_object_version_number number;
2257: l_datetrack_update_mode varchar2(30);
2258: l_last_change_date date;
2259: l_review_proc_call varchar2(4000);

Line 2325: (p_grade_ladder_id in per_all_assignments_f.grade_ladder_pgm_id%TYPE ,

2321:
2322: -- cursor to find whether assigned grade ladder id updates
2323: -- the salary using Grade Step Progression
2324: CURSOR lc_sal_updateable_grade_ladder
2325: (p_grade_ladder_id in per_all_assignments_f.grade_ladder_pgm_id%TYPE ,
2326: p_effective_date in date
2327: ) IS
2328: select pgm_id, update_salary_cd from ben_pgm_f
2329: where

Line 2353: -- per_all_assignments_f

2349: and effective_end_date;
2350:
2351: --
2352: -- cursor to get the applicant object_version_number from
2353: -- per_all_assignments_f
2354: cursor asg_applicant_rec(p_appl_assign_id in number,
2355: p_appl_effective_date in date) is
2356: select object_version_number,
2357: assignment_status_type_id

Line 2358: from per_all_assignments_f

2354: cursor asg_applicant_rec(p_appl_assign_id in number,
2355: p_appl_effective_date in date) is
2356: select object_version_number,
2357: assignment_status_type_id
2358: from per_all_assignments_f
2359: where assignment_id = p_appl_assign_id
2360: and p_appl_effective_date between effective_start_date
2361: and effective_end_date;
2362:

Line 2367: from per_all_assignments_f asf,

2363: --
2364:
2365: cursor last_change_date is
2366: select max(asf.effective_start_date)
2367: from per_all_assignments_f asf,
2368: per_assignment_status_types past
2369: where asf.assignment_id=l_assignment_id
2370: and asf.ASSIGNMENT_STATUS_TYPE_ID = past.ASSIGNMENT_STATUS_TYPE_ID;
2371: -- ns 10-May-03: Since termination is handled on the effective date page

Line 2379: from per_all_assignments_f asf,

2375:
2376: -- New cursor to see if any assignment record exist for the selected date
2377: cursor correction_date is
2378: select null
2379: from per_all_assignments_f asf,
2380: per_assignment_status_types past
2381: where asf.assignment_id = l_assignment_id
2382: and asf.assignment_status_type_id = past.assignment_status_type_id
2383: and asf.effective_start_date = l_effective_date;

Line 2410: from per_all_assignments_f

2406: where grade_id = p_id;
2407:
2408: cursor csr_assignment is
2409: select assignment_id
2410: from per_all_assignments_f
2411: where assignment_id = p_assignment_id;
2412:
2413: cursor process_order(l_item_type in varchar2,l_item_key in varchar2) is
2414: select processing_order from hr_api_transaction_steps where

Line 2450: from per_all_assignments_f

2446: l_person_type_id number;
2447:
2448: cursor csr_get_prim_asg is
2449: select *
2450: from per_all_assignments_f
2451: where person_id = l_person_id and primary_flag = 'Y' and assignment_type = 'E'
2452: and l_effective_date between effective_start_date and effective_end_date;
2453: --
2454: begin

Line 2487: select object_version_number into l_object_version_number from per_all_assignments_f where assignment_id = l_assignment_id;

2483: ,AssignmentId => l_assignment_id
2484: ,p_error_message => p_page_error_msg
2485: ,p_source => 'Assignment');
2486: begin
2487: select object_version_number into l_object_version_number from per_all_assignments_f where assignment_id = l_assignment_id;
2488: exception
2489: when others then
2490: null;
2491: end;

Line 4443: -- per_all_assignments_f

4439: -- Need to use the latest object version number and also assginment_status_type_id
4440: -- before calling the update_assignment as the above api call will change the object
4441: -- version number and update the assignment record in correction mode
4442: -- first get the object_version_number for the applicant from
4443: -- per_all_assignments_f
4444: open asg_applicant_rec(l_assignment_id, l_effective_date);
4445: fetch asg_applicant_rec into l_object_version_number
4446: ,l_assignment_rec.assignment_status_type_id;
4447: close asg_applicant_rec;

Line 5951: from per_all_assignments_f

5947: ,p_login_person_id in number) is
5948:
5949: cursor csr_new_object_number(p_asg_id in number) is
5950: select object_version_number
5951: from per_all_assignments_f
5952: where assignment_id = p_asg_id
5953: and assignment_type = 'E'
5954: order by object_version_number desc;
5955:

Line 5998: l_assignment_rec per_all_assignments_f%rowtype;

5994: ,p_transaction_step_id in number
5995: ,p_effective_date in varchar2 default null
5996: ) is
5997:
5998: l_assignment_rec per_all_assignments_f%rowtype;
5999: l_effective_date date;
6000: l_datetrack_update_mode varchar2(30);
6001: l_j_changed varchar2(2) := 'N';
6002: --

Line 6003: l_special_ceiling_step_id per_all_assignments_f.special_ceiling_step_id%TYPE;

5999: l_effective_date date;
6000: l_datetrack_update_mode varchar2(30);
6001: l_j_changed varchar2(2) := 'N';
6002: --
6003: l_special_ceiling_step_id per_all_assignments_f.special_ceiling_step_id%TYPE;
6004: l_effective_start_date date;
6005: l_effective_end_date date;
6006: l_people_group_id per_all_assignments_f.people_group_id%TYPE;
6007: l_group_name VARCHAR2(2000);

Line 6006: l_people_group_id per_all_assignments_f.people_group_id%TYPE;

6002: --
6003: l_special_ceiling_step_id per_all_assignments_f.special_ceiling_step_id%TYPE;
6004: l_effective_start_date date;
6005: l_effective_end_date date;
6006: l_people_group_id per_all_assignments_f.people_group_id%TYPE;
6007: l_group_name VARCHAR2(2000);
6008: l_org_now_no_manager_warning boolean;
6009: l_other_manager_warning boolean;
6010: l_spp_delete_warning boolean;

Line 6013: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;

6009: l_other_manager_warning boolean;
6010: l_spp_delete_warning boolean;
6011: l_entries_changed_warning VARCHAR2(30);
6012: l_tax_district_changed_warning boolean;
6013: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;
6014: l_comment_id per_all_assignments_f.comment_id%TYPE;
6015: l_concatenated_segments VARCHAR2(2000);
6016: l_element_changed VARCHAR2(1) default 'W';
6017:

Line 6014: l_comment_id per_all_assignments_f.comment_id%TYPE;

6010: l_spp_delete_warning boolean;
6011: l_entries_changed_warning VARCHAR2(30);
6012: l_tax_district_changed_warning boolean;
6013: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;
6014: l_comment_id per_all_assignments_f.comment_id%TYPE;
6015: l_concatenated_segments VARCHAR2(2000);
6016: l_element_changed VARCHAR2(1) default 'W';
6017:
6018: l_page_error varchar2(2000);

Line 6036: l_appl_assignment_type per_all_assignments_f.assignment_type%type;

6032: l_location_error varchar2(2000);
6033: l_location_error_msg varchar2(2000);
6034:
6035: -- variables and cursors for applicant_hire
6036: l_appl_assignment_type per_all_assignments_f.assignment_type%type;
6037: l_new_hire_appl_hire varchar2(10);
6038: l_login_person_id number;
6039:
6040: -- GSP

Line 6047: -- per_all_assignments_f

6043: l_proc varchar2(72) := g_package||'process_api';
6044: -- End of GSP
6045:
6046: -- cursor to get the applicant object_version_number from
6047: -- per_all_assignments_f
6048: cursor asg_applicant_rec(p_appl_assign_id in number,
6049: p_appl_effective_date in date) is
6050: select object_version_number,
6051: assignment_type,

Line 6053: from per_all_assignments_f

6049: p_appl_effective_date in date) is
6050: select object_version_number,
6051: assignment_type,
6052: assignment_status_type_id
6053: from per_all_assignments_f
6054: where assignment_id = p_appl_assign_id
6055: and p_appl_effective_date between effective_start_date
6056: and effective_end_date;
6057:

Line 6438: p_assignment_rec in out nocopy per_all_assignments_f%rowtype,

6434: end process_api;
6435:
6436: procedure update_apl_assignment
6437: (p_validate in boolean default false,
6438: p_assignment_rec in out nocopy per_all_assignments_f%rowtype,
6439: p_effective_date in date,
6440: p_person_id in number,
6441: p_appl_assignment_id in number,
6442: p_person_type_id in number,

Line 6452: l_assignment_rec per_all_assignments_f%rowtype := p_assignment_rec;

6448: l_unaccepted_asg_del_warning boolean;
6449: l_assign_payroll_warning boolean;
6450: l_oversubscribed_vacancy_id number;
6451: l_ovn number := p_ovn;
6452: l_assignment_rec per_all_assignments_f%rowtype := p_assignment_rec;
6453:
6454: cursor csr_prim_asg is
6455: select assignment_id from per_all_assignments_f where
6456: person_id = p_person_id and primary_flag='Y' and assignment_type='E' and

Line 6455: select assignment_id from per_all_assignments_f where

6451: l_ovn number := p_ovn;
6452: l_assignment_rec per_all_assignments_f%rowtype := p_assignment_rec;
6453:
6454: cursor csr_prim_asg is
6455: select assignment_id from per_all_assignments_f where
6456: person_id = p_person_id and primary_flag='Y' and assignment_type='E' and
6457: p_effective_date between effective_start_date and effective_end_date;
6458:
6459: l_prim_asgid number;

Line 6461: l_supervisor_assignment_id per_all_assignments_f.supervisor_assignment_id%TYPE;

6457: p_effective_date between effective_start_date and effective_end_date;
6458:
6459: l_prim_asgid number;
6460: -- Fix for the BUG13595937 starts
6461: l_supervisor_assignment_id per_all_assignments_f.supervisor_assignment_id%TYPE;
6462: CURSOR csr_get_sup_Ass_id(p_assignment_id in number) is
6463: select supervisor_assignment_id from per_all_assignments_f
6464: where assignment_id = p_assignment_id;
6465: -- Fix for the BUG13595937 ends

Line 6463: select supervisor_assignment_id from per_all_assignments_f

6459: l_prim_asgid number;
6460: -- Fix for the BUG13595937 starts
6461: l_supervisor_assignment_id per_all_assignments_f.supervisor_assignment_id%TYPE;
6462: CURSOR csr_get_sup_Ass_id(p_assignment_id in number) is
6463: select supervisor_assignment_id from per_all_assignments_f
6464: where assignment_id = p_assignment_id;
6465: -- Fix for the BUG13595937 ends
6466:
6467: begin

Line 6577: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE

6573: ,p_job_post_source_name in varchar2 default null
6574: ,p_perf_review_period in number default null
6575: ,p_perf_review_period_frequency in varchar2 default null
6576: ,p_internal_address_line in varchar2 default null
6577: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
6578: -- GSP change
6579: ,p_grade_ladder_pgm_id in per_all_assignments_f.grade_ladder_pgm_id%TYPE
6580: -- GSP change
6581: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE

Line 6579: ,p_grade_ladder_pgm_id in per_all_assignments_f.grade_ladder_pgm_id%TYPE

6575: ,p_perf_review_period_frequency in varchar2 default null
6576: ,p_internal_address_line in varchar2 default null
6577: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
6578: -- GSP change
6579: ,p_grade_ladder_pgm_id in per_all_assignments_f.grade_ladder_pgm_id%TYPE
6580: -- GSP change
6581: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
6582: --,p_supervisor_assignment_id in per_all_assignments_f.supervisor_assignment_id%TYPE
6583: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE

Line 6581: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE

6577: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
6578: -- GSP change
6579: ,p_grade_ladder_pgm_id in per_all_assignments_f.grade_ladder_pgm_id%TYPE
6580: -- GSP change
6581: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
6582: --,p_supervisor_assignment_id in per_all_assignments_f.supervisor_assignment_id%TYPE
6583: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
6584: ,p_special_ceiling_step_id in out nocopy per_all_assignments_f.special_ceiling_step_id%TYPE
6585: ,p_primary_flag in per_all_assignments_f.primary_flag%TYPE

Line 6582: --,p_supervisor_assignment_id in per_all_assignments_f.supervisor_assignment_id%TYPE

6578: -- GSP change
6579: ,p_grade_ladder_pgm_id in per_all_assignments_f.grade_ladder_pgm_id%TYPE
6580: -- GSP change
6581: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
6582: --,p_supervisor_assignment_id in per_all_assignments_f.supervisor_assignment_id%TYPE
6583: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
6584: ,p_special_ceiling_step_id in out nocopy per_all_assignments_f.special_ceiling_step_id%TYPE
6585: ,p_primary_flag in per_all_assignments_f.primary_flag%TYPE
6586: ,p_person_id in per_all_assignments_f.person_id%TYPE

Line 6583: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE

6579: ,p_grade_ladder_pgm_id in per_all_assignments_f.grade_ladder_pgm_id%TYPE
6580: -- GSP change
6581: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
6582: --,p_supervisor_assignment_id in per_all_assignments_f.supervisor_assignment_id%TYPE
6583: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
6584: ,p_special_ceiling_step_id in out nocopy per_all_assignments_f.special_ceiling_step_id%TYPE
6585: ,p_primary_flag in per_all_assignments_f.primary_flag%TYPE
6586: ,p_person_id in per_all_assignments_f.person_id%TYPE
6587: ,p_effective_start_date out nocopy date

Line 6584: ,p_special_ceiling_step_id in out nocopy per_all_assignments_f.special_ceiling_step_id%TYPE

6580: -- GSP change
6581: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
6582: --,p_supervisor_assignment_id in per_all_assignments_f.supervisor_assignment_id%TYPE
6583: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
6584: ,p_special_ceiling_step_id in out nocopy per_all_assignments_f.special_ceiling_step_id%TYPE
6585: ,p_primary_flag in per_all_assignments_f.primary_flag%TYPE
6586: ,p_person_id in per_all_assignments_f.person_id%TYPE
6587: ,p_effective_start_date out nocopy date
6588: ,p_effective_end_date out nocopy date

Line 6585: ,p_primary_flag in per_all_assignments_f.primary_flag%TYPE

6581: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
6582: --,p_supervisor_assignment_id in per_all_assignments_f.supervisor_assignment_id%TYPE
6583: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
6584: ,p_special_ceiling_step_id in out nocopy per_all_assignments_f.special_ceiling_step_id%TYPE
6585: ,p_primary_flag in per_all_assignments_f.primary_flag%TYPE
6586: ,p_person_id in per_all_assignments_f.person_id%TYPE
6587: ,p_effective_start_date out nocopy date
6588: ,p_effective_end_date out nocopy date
6589: ,p_element_warning in boolean

Line 6586: ,p_person_id in per_all_assignments_f.person_id%TYPE

6582: --,p_supervisor_assignment_id in per_all_assignments_f.supervisor_assignment_id%TYPE
6583: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
6584: ,p_special_ceiling_step_id in out nocopy per_all_assignments_f.special_ceiling_step_id%TYPE
6585: ,p_primary_flag in per_all_assignments_f.primary_flag%TYPE
6586: ,p_person_id in per_all_assignments_f.person_id%TYPE
6587: ,p_effective_start_date out nocopy date
6588: ,p_effective_end_date out nocopy date
6589: ,p_element_warning in boolean
6590: ,p_element_changed in out nocopy varchar2

Line 6629: l_object_version_number per_all_assignments_f.object_version_number%TYPE;

6625: ) is
6626: --
6627:
6628: l_effective_date date;
6629: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
6630: l_effective_start_date date;
6631: l_effective_end_date date;
6632: -- Fix for 3633612 to pass new people group flx ccid to hr_assignment_api, so that these
6633: -- hr_assignment_api's won't validate the old segment values.

Line 6634: l_people_group_id per_all_assignments_f.people_group_id%TYPE

6630: l_effective_start_date date;
6631: l_effective_end_date date;
6632: -- Fix for 3633612 to pass new people group flx ccid to hr_assignment_api, so that these
6633: -- hr_assignment_api's won't validate the old segment values.
6634: l_people_group_id per_all_assignments_f.people_group_id%TYPE
6635: := p_people_group_id;
6636: l_group_name VARCHAR2(2000);
6637: l_org_now_no_manager_warning boolean;
6638: l_other_manager_warning boolean;

Line 6642: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;

6638: l_other_manager_warning boolean;
6639: l_spp_delete_warning boolean;
6640: l_entries_changed_warning VARCHAR2(30);
6641: l_tax_district_changed_warning boolean;
6642: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;
6643: l_cagr_grade_def_id per_all_assignments_f.cagr_grade_def_id%TYPE;
6644: l_cagr_concatenated_segments varchar2(2000);
6645: l_comment_id per_all_assignments_f.comment_id%TYPE;
6646: l_concatenated_segments VARCHAR2(2000);

Line 6643: l_cagr_grade_def_id per_all_assignments_f.cagr_grade_def_id%TYPE;

6639: l_spp_delete_warning boolean;
6640: l_entries_changed_warning VARCHAR2(30);
6641: l_tax_district_changed_warning boolean;
6642: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;
6643: l_cagr_grade_def_id per_all_assignments_f.cagr_grade_def_id%TYPE;
6644: l_cagr_concatenated_segments varchar2(2000);
6645: l_comment_id per_all_assignments_f.comment_id%TYPE;
6646: l_concatenated_segments VARCHAR2(2000);
6647: l_hourly_salaried_warning boolean default false;

Line 6645: l_comment_id per_all_assignments_f.comment_id%TYPE;

6641: l_tax_district_changed_warning boolean;
6642: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;
6643: l_cagr_grade_def_id per_all_assignments_f.cagr_grade_def_id%TYPE;
6644: l_cagr_concatenated_segments varchar2(2000);
6645: l_comment_id per_all_assignments_f.comment_id%TYPE;
6646: l_concatenated_segments VARCHAR2(2000);
6647: l_hourly_salaried_warning boolean default false;
6648: l_validation_start_date per_assignments_f.effective_start_date%TYPE;
6649: l_validation_end_date per_assignments_f.effective_end_date%TYPE;

Line 6674: from per_all_assignments_f

6670: l_proc varchar2(72) := g_package||'update_assignment';
6671: --
6672: cursor current_job_id is
6673: select job_id
6674: from per_all_assignments_f
6675: where assignment_id=p_assignment_id
6676: and l_effective_date between effective_start_date and effective_end_date;
6677:
6678: --

Line 6738: per_all_assignments_f asg

6734:
6735: cursor csr_default_gre is
6736: select scl.segment1
6737: from hr_soft_coding_keyflex scl,
6738: per_all_assignments_f asg
6739: where asg.person_id = p_login_person_id
6740: and asg.business_group_id = p_business_group_id --the new hire business group
6741: and asg.primary_flag = 'Y'
6742: and trunc(sysdate) between asg.effective_start_date

Line 6792: from per_all_assignments_f asg

6788: cursor check_payroll_scl is
6789: select asg.assignment_id,
6790: asg.payroll_id,
6791: asg.soft_coding_keyflex_id
6792: from per_all_assignments_f asg
6793: where asg.person_id = p_person_id
6794: and l_effective_date between asg.effective_start_date
6795: and asg.effective_end_date
6796: and asg.assignment_type = 'E'

Line 6954: update per_all_assignments_f set soft_coding_keyflex_id = p_soft_coding_keyflex_id

6950: end if;
6951:
6952: if (p_new_hire_appl_hire = 'Y' and l_legislation_code = 'US') then
6953: for c in check_payroll_scl loop
6954: update per_all_assignments_f set soft_coding_keyflex_id = p_soft_coding_keyflex_id
6955: where assignment_id = c.assignment_id and l_effective_date between
6956: effective_start_date and effective_end_date;
6957: end loop;
6958: end if;

Line 7266: from per_all_assignments_f

7262: -- bug 5547271
7263: if (hr_process_person_ss.g_is_applicant) then
7264: begin
7265: select PAYROLL_ID into l_old_payroll_id
7266: from per_all_assignments_f
7267: where assignment_id = p_assignment_id and p_effective_date between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE;
7268: end;
7269: hrentmnt.maintain_entries_asg
7270: (p_assignment_id => p_assignment_id

Line 7802: select primary_flag into l_primary_flag from per_all_assignments_f

7798: l_assignment_id number;
7799: l_effective_date date;
7800:
7801: cursor csr_prim_flag is
7802: select primary_flag into l_primary_flag from per_all_assignments_f
7803: where assignment_id = l_assignment_id and trunc(l_effective_date)
7804: between effective_start_date and effective_end_date;
7805:
7806: begin