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

Line 20: ,p_assignment_id IN per_all_assignments_f.assignment_id%type --2264191 added

16: --
17: CURSOR csr_future_asgs
18: (p_person_id IN per_all_people_f.person_id%TYPE
19: ,p_effective_date IN DATE
20: ,p_assignment_id IN per_all_assignments_f.assignment_id%type --2264191 added
21: )
22: IS
23: SELECT asg.assignment_id
24: ,asg.object_version_number

Line 51: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE DEFAULT hr_api.g_number

47: --
48: CURSOR csr_accepted_asgs
49: (p_person_id IN per_all_people_f.person_id%TYPE
50: ,p_effective_date IN DATE
51: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE DEFAULT hr_api.g_number
52: )
53: IS
54: SELECT asg.assignment_id
55: ,asg.object_version_number

Line 167: ,p_assignment_id IN per_all_assignments_f.assignment_id%type DEFAULT NULL --2264191 added

163: --
164: FUNCTION future_asgs_count
165: (p_person_id IN per_all_people_f.person_id%TYPE
166: ,p_effective_date IN DATE
167: ,p_assignment_id IN per_all_assignments_f.assignment_id%type DEFAULT NULL --2264191 added
168: )
169: RETURN INTEGER
170: IS
171: --

Line 637: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE DEFAULT NULL

633: ,p_hire_date IN DATE
634: ,p_person_id IN per_all_people_f.person_id%TYPE
635: ,p_per_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
636: ,p_person_type_id IN per_person_types.person_type_id%TYPE DEFAULT NULL
637: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE DEFAULT NULL
638: ,p_employee_number IN OUT NOCOPY per_all_people_f.employee_number%TYPE
639: ,p_per_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
640: ,p_per_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE
641: ,p_assign_payroll_warning OUT NOCOPY BOOLEAN

Line 701: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE DEFAULT NULL

697: ,p_hire_date IN DATE
698: ,p_person_id IN per_all_people_f.person_id%TYPE
699: ,p_per_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
700: ,p_person_type_id IN per_person_types.person_type_id%TYPE DEFAULT NULL
701: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE DEFAULT NULL
702: ,p_employee_number IN OUT NOCOPY per_all_people_f.employee_number%TYPE
703: ,p_per_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
704: ,p_per_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE
705: ,p_assign_payroll_warning OUT NOCOPY BOOLEAN

Line 767: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE DEFAULT NULL

763: ,p_person_id IN per_all_people_f.person_id%TYPE
764: ,p_per_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
765: ,p_person_type_id IN per_person_types.person_type_id%TYPE DEFAULT NULL
766: ,p_hire_all_accepted_asgs IN VARCHAR2
767: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE DEFAULT NULL
768: ,p_national_identifier IN per_all_people_f.national_identifier%TYPE DEFAULT hr_api.g_varchar2
769: ,p_employee_number IN OUT NOCOPY per_all_people_f.employee_number%TYPE
770: ,p_per_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
771: ,p_per_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE

Line 815: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE DEFAULT NULL

811: ,p_person_id IN per_all_people_f.person_id%TYPE
812: ,p_per_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
813: ,p_person_type_id IN per_person_types.person_type_id%TYPE DEFAULT NULL
814: ,p_hire_all_accepted_asgs IN VARCHAR2
815: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE DEFAULT NULL
816: ,p_national_identifier IN per_all_people_f.national_identifier%TYPE DEFAULT hr_api.g_varchar2
817: ,p_employee_number IN OUT NOCOPY per_all_people_f.employee_number%TYPE
818: ,p_per_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
819: ,p_per_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE

Line 835: l_new_primary_asg_id per_all_assignments_f.assignment_id%TYPE;

831: l_ovn per_all_people_f.object_version_number%TYPE := p_per_object_version_number;
832: l_person_type_id per_person_types.person_type_id%TYPE := p_person_type_id;
833: l_person_type_id1 per_person_types.person_type_id%TYPE;
834: --
835: l_new_primary_asg_id per_all_assignments_f.assignment_id%TYPE;
836: l_hire_all_accepted_asgs VARCHAR2(1);
837: l_hire_single_asg_id per_all_assignments_f.assignment_id%TYPE;
838: --
839: l_per_object_version_number CONSTANT per_all_people_f.object_version_number%TYPE := p_per_object_version_number;

Line 837: l_hire_single_asg_id per_all_assignments_f.assignment_id%TYPE;

833: l_person_type_id1 per_person_types.person_type_id%TYPE;
834: --
835: l_new_primary_asg_id per_all_assignments_f.assignment_id%TYPE;
836: l_hire_all_accepted_asgs VARCHAR2(1);
837: l_hire_single_asg_id per_all_assignments_f.assignment_id%TYPE;
838: --
839: l_per_object_version_number CONSTANT per_all_people_f.object_version_number%TYPE := p_per_object_version_number;
840: l_employee_number CONSTANT per_all_people_f.employee_number%TYPE := p_employee_number;
841: l_emp_num CONSTANT per_all_people_f.employee_number%TYPE := p_employee_number;

Line 853: l_primary_flag per_all_assignments_f.primary_flag%TYPE;

849: l_nonaccepted_asgs_count INTEGER;
850: l_accepted_asgs_count INTEGER;
851: l_primary_asgs_count INTEGER;
852: l_assignment_status_type_id per_assignment_status_types.assignment_status_type_id%TYPE;
853: l_primary_flag per_all_assignments_f.primary_flag%TYPE;
854: --
855: l_effective_start_date DATE;
856: l_effective_end_date DATE;
857: l_validation_start_date DATE;

Line 888: from per_all_assignments_f asg

884: from per_all_vacancies vac
885: where vac.vacancy_id=p_vacancy_id
886: and vac.number_of_openings <
887: (select count(distinct assignment_id)
888: from per_all_assignments_f asg
889: where asg.vacancy_id=p_vacancy_id
890: and asg.assignment_type='E');
891: --
892: cursor csr_future_per_changes(p_effective_date DATE) is

Line 902: from per_all_assignments_f

898:
899: -- Start changes for bug 9879782
900: cursor csr_get_appl_id(lp_assignment_id number) is
901: select application_id
902: from per_all_assignments_f
903: where assignment_id = lp_assignment_id
904: and p_hire_date between effective_start_date and effective_end_date;
905:
906: l_appl_id number;

Line 1769: l_primary_asg_id per_all_assignments_f.assignment_id%type;

1765: l_org_now_no_manager_warning boolean;
1766: l_hourly_salaried_warning boolean;
1767: l_datetrack_update_mode varchar2(30);
1768: --
1769: l_primary_asg_id per_all_assignments_f.assignment_id%type;
1770: l_primary_ovn per_all_assignments_f.object_version_number%type;
1771: l_dummy number;
1772: l_dummy1 number;
1773: l_dummy2 number;

Line 1770: l_primary_ovn per_all_assignments_f.object_version_number%type;

1766: l_hourly_salaried_warning boolean;
1767: l_datetrack_update_mode varchar2(30);
1768: --
1769: l_primary_asg_id per_all_assignments_f.assignment_id%type;
1770: l_primary_ovn per_all_assignments_f.object_version_number%type;
1771: l_dummy number;
1772: l_dummy1 number;
1773: l_dummy2 number;
1774: l_dummyv varchar2(700);

Line 1792: from per_all_assignments_f asg

1788: and asg.effective_start_date > p_hire_date;
1789: -- ER FPT
1790: cursor fpt_future_asg_changes is
1791: select 'x'
1792: from per_all_assignments_f asg
1793: where asg.person_id = p_person_id
1794: and asg.effective_start_date >= p_hire_date
1795: and asg.assignment_type = 'E';
1796:

Line 1890: from per_all_assignments_f

1886: --
1887: --
1888: cursor get_primary is
1889: select assignment_id,object_version_number, period_of_service_id -- #2468916
1890: from per_all_assignments_f
1891: where person_id=p_person_id
1892: and primary_flag='Y'
1893: and l_hire_date between effective_start_date and effective_end_date
1894: and assignment_type='E';

Line 1898: from per_all_assignments_f asg

1894: and assignment_type='E';
1895: --
1896: cursor get_asg(p_assignment_id number) is
1897: select *
1898: from per_all_assignments_f asg
1899: where asg.assignment_id=p_assignment_id
1900: and l_hire_date between asg.effective_start_date
1901: and asg.effective_end_date;
1902: --

Line 1903: l_asg_rec per_all_assignments_f%rowtype;

1899: where asg.assignment_id=p_assignment_id
1900: and l_hire_date between asg.effective_start_date
1901: and asg.effective_end_date;
1902: --
1903: l_asg_rec per_all_assignments_f%rowtype;
1904: l_primary_asg_rec per_all_assignments_f%rowtype;
1905: --
1906: cursor get_pgp(p_people_group_id number) is
1907: select *

Line 1904: l_primary_asg_rec per_all_assignments_f%rowtype;

1900: and l_hire_date between asg.effective_start_date
1901: and asg.effective_end_date;
1902: --
1903: l_asg_rec per_all_assignments_f%rowtype;
1904: l_primary_asg_rec per_all_assignments_f%rowtype;
1905: --
1906: cursor get_pgp(p_people_group_id number) is
1907: select *
1908: from pay_people_groups

Line 1936: from per_all_assignments_f asg

1932: from per_all_vacancies vac
1933: where vac.vacancy_id=p_vacancy_id
1934: and vac.number_of_openings <
1935: (select count(distinct assignment_id)
1936: from per_all_assignments_f asg
1937: where asg.vacancy_id=p_vacancy_id
1938: and asg.assignment_type='E');
1939: --
1940: -- Bug 4644830 Start

Line 1941: cursor get_pay_proposal(ass_id per_all_assignments_f.assignment_id%type) is

1937: where asg.vacancy_id=p_vacancy_id
1938: and asg.assignment_type='E');
1939: --
1940: -- Bug 4644830 Start
1941: cursor get_pay_proposal(ass_id per_all_assignments_f.assignment_id%type) is
1942: select pay_proposal_id,object_version_number,proposed_salary_n, change_date, proposal_reason -- Added For Bug 5987409 --
1943: from per_pay_proposals
1944: where assignment_id=ass_id
1945: and approved = 'N'

Line 1959: l_pspl_asg_id per_all_assignments_f.assignment_id%type;

1955: l_proposal_reason per_pay_proposals.proposal_reason%TYPE; -- Added For Bug 5987409 --
1956: -- Bug 4644830 End
1957: --
1958: -- start of bug 4641965
1959: l_pspl_asg_id per_all_assignments_f.assignment_id%type;
1960: cursor get_primary_proposal(ass_id per_all_assignments_f.assignment_id%type) is
1961: select pay_proposal_id,object_version_number
1962: from per_pay_proposals
1963: where assignment_id=ass_id

Line 1960: cursor get_primary_proposal(ass_id per_all_assignments_f.assignment_id%type) is

1956: -- Bug 4644830 End
1957: --
1958: -- start of bug 4641965
1959: l_pspl_asg_id per_all_assignments_f.assignment_id%type;
1960: cursor get_primary_proposal(ass_id per_all_assignments_f.assignment_id%type) is
1961: select pay_proposal_id,object_version_number
1962: from per_pay_proposals
1963: where assignment_id=ass_id
1964: and APPROVED='N';

Line 1971: from per_all_assignments_f PAAF

1967: --Bug 4959033 starts here
1968:
1969: cursor get_business_group(p_asg_id number) is
1970: select distinct PAAF.business_group_id
1971: from per_all_assignments_f PAAF
1972: where PAAF.assignment_id=p_asg_id;
1973: l_bg_id number;
1974:
1975: cursor get_primary_approved_proposal(ass_id per_all_assignments_f.assignment_id%type) is

Line 1975: cursor get_primary_approved_proposal(ass_id per_all_assignments_f.assignment_id%type) is

1971: from per_all_assignments_f PAAF
1972: where PAAF.assignment_id=p_asg_id;
1973: l_bg_id number;
1974:
1975: cursor get_primary_approved_proposal(ass_id per_all_assignments_f.assignment_id%type) is
1976: select pay_proposal_id
1977: from per_pay_proposals
1978: where assignment_id=ass_id
1979: and APPROVED='Y';

Line 1984: l_pay_basis_id per_all_assignments_f.pay_basis_id%type;

1980:
1981: --Bug 4959033 ends here
1982: --
1983: --Bug 5102289 starts here
1984: l_pay_basis_id per_all_assignments_f.pay_basis_id%type;
1985: l_approved varchar2(10);
1986: cursor get_primary_pay_basis(p_asg_id number) is
1987: select PAAF.pay_basis_id
1988: from per_all_assignments_f PAAF

Line 1988: from per_all_assignments_f PAAF

1984: l_pay_basis_id per_all_assignments_f.pay_basis_id%type;
1985: l_approved varchar2(10);
1986: cursor get_primary_pay_basis(p_asg_id number) is
1987: select PAAF.pay_basis_id
1988: from per_all_assignments_f PAAF
1989: where PAAF.assignment_id=p_asg_id;
1990: --Bug 5102289 ends here
1991:
1992: -- Start changes for bug 9879782

Line 1995: from per_all_assignments_f

1991:
1992: -- Start changes for bug 9879782
1993: cursor csr_get_appl_id(lp_assignment_id number) is
1994: select application_id
1995: from per_all_assignments_f
1996: where assignment_id = lp_assignment_id
1997: and p_hire_date between effective_start_date and effective_end_date;
1998:
1999: l_appl_id number;

Line 2011: select 'Y' from per_all_assignments_f

2007: l_new_application_id number;
2008: l_yes_backtoback varchar2(1) := 'N';
2009:
2010: cursor chk_future_changes(p_assignment_id number) is
2011: select 'Y' from per_all_assignments_f
2012: where person_id = p_person_id
2013: and assignment_id = p_assignment_id
2014: and effective_start_date >= p_hire_date;
2015:

Line 2028: from per_all_assignments_f

2024: and date_received = p_date_end +1;
2025:
2026: cursor fut_asg_rec is
2027: select assignment_id, effective_start_date, effective_end_date
2028: from per_all_assignments_f
2029: where person_id = p_person_id
2030: and assignment_type = 'A'
2031: and effective_start_date > l_hire_date
2032: and application_id = l_application_id

Line 3714: from per_all_assignments_f

3710: l_fpt_hire_flag :='Y';
3711:
3712: -- retrieve the max end date of the ASG to update the APLN date_end
3713: select max(effective_end_date) into l_apl_end_date
3714: from per_all_assignments_f
3715: where person_id = p_person_id
3716: and assignment_id = apl.assignment_id
3717: and assignment_type = 'A';
3718:

Line 3761: update per_all_assignments_f

3757:
3758: close chk_apl_exists;
3759:
3760: -- update the ASG with the correct APLN ID
3761: update per_all_assignments_f
3762: set application_id = l_cur_apl_id
3763: where person_id = p_person_id
3764: and assignment_id = apl.assignment_id
3765: and effective_start_date = apl.effective_start_date

Line 3999: ,p_id per_all_assignments_f.assignment_id%TYPE)

3995: -- LOCATE_ELEMENT:
3996: -- Returns the location of a particular ID in the array.
3997: -- +-------------------------------------------------------------------------+
3998: function locate_element(p_table t_ApplTable
3999: ,p_id per_all_assignments_f.assignment_id%TYPE)
4000: return binary_integer is
4001: --
4002: l_index number;
4003: l_max_ele number;

Line 4067: ,p_id per_all_assignments_f.assignment_id%TYPE)

4063: -- 1: if END DATE value has been stored in
4064: -- 2: a different value has been found.
4065: -- +-------------------------------------------------------------------------+
4066: function end_date_exists(p_table t_ApplTable
4067: ,p_id per_all_assignments_f.assignment_id%TYPE)
4068: return integer is
4069: l_index binary_integer;
4070: begin
4071: l_index := locate_element(p_table, p_id);

Line 4092: ,p_id per_all_assignments_f.assignment_id%TYPE)

4088: -- assignments that have been ACCEPTED. The null value reflects a default
4089: -- value of 'Convert into secondary'.
4090: -- +-------------------------------------------------------------------------+
4091: function is_convert(p_table t_ApplTable
4092: ,p_id per_all_assignments_f.assignment_id%TYPE)
4093: return boolean is
4094: l_index binary_integer;
4095: begin
4096:

Line 4155: p_asg_rec in out nocopy per_all_assignments_f%rowtype,

4151: --
4152: procedure hire_employee_applicant
4153: (p_validate in boolean default false,
4154: p_hire_date in date,
4155: p_asg_rec in out nocopy per_all_assignments_f%rowtype,
4156: p_person_id in per_all_people_f.person_id%TYPE,
4157: p_primary_assignment_id in number default null,
4158: p_person_type_id in number default null,
4159: p_overwrite_primary in varchar2 default 'N',

Line 4234: l_primary_asg_id per_all_assignments_f.assignment_id%type;

4230: l_org_now_no_manager_warning boolean;
4231: l_hourly_salaried_warning boolean;
4232: l_datetrack_update_mode varchar2(30);
4233: --
4234: l_primary_asg_id per_all_assignments_f.assignment_id%type;
4235: l_primary_ovn per_all_assignments_f.object_version_number%type;
4236: l_dummy number;
4237: l_dummy1 number;
4238: l_dummy2 number;

Line 4235: l_primary_ovn per_all_assignments_f.object_version_number%type;

4231: l_hourly_salaried_warning boolean;
4232: l_datetrack_update_mode varchar2(30);
4233: --
4234: l_primary_asg_id per_all_assignments_f.assignment_id%type;
4235: l_primary_ovn per_all_assignments_f.object_version_number%type;
4236: l_dummy number;
4237: l_dummy1 number;
4238: l_dummy2 number;
4239: l_dummyv varchar2(700);

Line 4265: from per_all_assignments_f asg

4261:
4262: -- ER FPT
4263: cursor fpt_future_asg_changes is
4264: select 'x'
4265: from per_all_assignments_f asg
4266: where asg.person_id = p_person_id
4267: and asg.effective_start_date >= p_hire_date
4268: and asg.assignment_type = 'E';
4269: --

Line 4371: from per_all_assignments_f

4367: --
4368: --
4369: cursor get_primary is
4370: select assignment_id,object_version_number, period_of_service_id -- #2468916
4371: from per_all_assignments_f
4372: where person_id=p_person_id
4373: and primary_flag='Y'
4374: and l_hire_date between effective_start_date and effective_end_date
4375: and assignment_type='E';

Line 4379: from per_all_assignments_f asg

4375: and assignment_type='E';
4376: --
4377: cursor get_asg(p_assignment_id number) is
4378: select *
4379: from per_all_assignments_f asg
4380: where asg.assignment_id=p_assignment_id
4381: and l_hire_date between asg.effective_start_date
4382: and asg.effective_end_date;
4383: --

Line 4384: l_asg_rec per_all_assignments_f%rowtype;

4380: where asg.assignment_id=p_assignment_id
4381: and l_hire_date between asg.effective_start_date
4382: and asg.effective_end_date;
4383: --
4384: l_asg_rec per_all_assignments_f%rowtype;
4385: l_primary_asg_rec per_all_assignments_f%rowtype;
4386: --
4387: cursor get_pgp(p_people_group_id number) is
4388: select *

Line 4385: l_primary_asg_rec per_all_assignments_f%rowtype;

4381: and l_hire_date between asg.effective_start_date
4382: and asg.effective_end_date;
4383: --
4384: l_asg_rec per_all_assignments_f%rowtype;
4385: l_primary_asg_rec per_all_assignments_f%rowtype;
4386: --
4387: cursor get_pgp(p_people_group_id number) is
4388: select *
4389: from pay_people_groups

Line 4417: from per_all_assignments_f asg

4413: from per_all_vacancies vac
4414: where vac.vacancy_id=p_vacancy_id
4415: and vac.number_of_openings <
4416: (select count(distinct assignment_id)
4417: from per_all_assignments_f asg
4418: where asg.vacancy_id=p_vacancy_id
4419: and asg.assignment_type='E');
4420: --
4421: -- Bug 4644830 Start

Line 4422: cursor get_pay_proposal(ass_id per_all_assignments_f.assignment_id%type) is

4418: where asg.vacancy_id=p_vacancy_id
4419: and asg.assignment_type='E');
4420: --
4421: -- Bug 4644830 Start
4422: cursor get_pay_proposal(ass_id per_all_assignments_f.assignment_id%type) is
4423: select pay_proposal_id,object_version_number,proposed_salary_n, change_date, proposal_reason -- Added For Bug 5987409 --
4424: from per_pay_proposals
4425: where assignment_id=ass_id
4426: and approved = 'N'

Line 4440: l_pspl_asg_id per_all_assignments_f.assignment_id%type;

4436: l_proposal_reason per_pay_proposals.proposal_reason%TYPE; -- Added For Bug 5987409 --
4437: -- Bug 4644830 End
4438: --
4439: -- start of bug 4641965
4440: l_pspl_asg_id per_all_assignments_f.assignment_id%type;
4441: cursor get_primary_proposal(ass_id per_all_assignments_f.assignment_id%type) is
4442: select pay_proposal_id,object_version_number
4443: from per_pay_proposals
4444: where assignment_id=ass_id

Line 4441: cursor get_primary_proposal(ass_id per_all_assignments_f.assignment_id%type) is

4437: -- Bug 4644830 End
4438: --
4439: -- start of bug 4641965
4440: l_pspl_asg_id per_all_assignments_f.assignment_id%type;
4441: cursor get_primary_proposal(ass_id per_all_assignments_f.assignment_id%type) is
4442: select pay_proposal_id,object_version_number
4443: from per_pay_proposals
4444: where assignment_id=ass_id
4445: and APPROVED='N';

Line 4452: from per_all_assignments_f PAAF

4448: --Bug 4959033 starts here
4449:
4450: cursor get_business_group(p_asg_id number) is
4451: select distinct PAAF.business_group_id
4452: from per_all_assignments_f PAAF
4453: where PAAF.assignment_id=p_asg_id;
4454: l_bg_id number;
4455:
4456: cursor get_primary_approved_proposal(ass_id per_all_assignments_f.assignment_id%type) is

Line 4456: cursor get_primary_approved_proposal(ass_id per_all_assignments_f.assignment_id%type) is

4452: from per_all_assignments_f PAAF
4453: where PAAF.assignment_id=p_asg_id;
4454: l_bg_id number;
4455:
4456: cursor get_primary_approved_proposal(ass_id per_all_assignments_f.assignment_id%type) is
4457: select pay_proposal_id
4458: from per_pay_proposals
4459: where assignment_id=ass_id
4460: and APPROVED='Y';

Line 4465: l_pay_basis_id per_all_assignments_f.pay_basis_id%type;

4461:
4462: --Bug 4959033 ends here
4463: --
4464: --Bug 5102289 starts here
4465: l_pay_basis_id per_all_assignments_f.pay_basis_id%type;
4466: l_approved varchar2(10);
4467: cursor get_primary_pay_basis(p_asg_id number) is
4468: select PAAF.pay_basis_id
4469: from per_all_assignments_f PAAF

Line 4469: from per_all_assignments_f PAAF

4465: l_pay_basis_id per_all_assignments_f.pay_basis_id%type;
4466: l_approved varchar2(10);
4467: cursor get_primary_pay_basis(p_asg_id number) is
4468: select PAAF.pay_basis_id
4469: from per_all_assignments_f PAAF
4470: where PAAF.assignment_id=p_asg_id;
4471: --Bug 5102289 ends here
4472: --
4473:

Line 4496: from per_all_assignments_f asg

4492:
4493: --- Fix For Bug # 8844816 Starts ---
4494: cursor csr_existing_SCL (crs_asg_id number) is
4495: select soft_coding_keyflex_id,payroll_id
4496: from per_all_assignments_f asg
4497: where asg.assignment_id = crs_asg_id
4498: -- and asg.primary_flag = 'Y'
4499: and trunc(sysdate) between asg.effective_start_date
4500: and asg.effective_end_date;

Line 4509: l_payroll_id per_all_assignments_f.payroll_id%type;

4505: from hr_soft_coding_keyflex
4506: where rownum=1;
4507:
4508: l_soft_coding_keyflex_id hr_soft_coding_keyflex.soft_coding_keyflex_id%type;
4509: l_payroll_id per_all_assignments_f.payroll_id%type;
4510: l_dummy_soft_coding_keyflex_id hr_soft_coding_keyflex.soft_coding_keyflex_id%type;
4511: --- Fix For Bug # 8844816 Ends ---
4512:
4513: -- vb 10376122

Line 4516: from per_all_assignments_f

4512:
4513: -- vb 10376122
4514: cursor csr_get_vacancy(p_asg_id number) is
4515: select vacancy_id,RECRUITER_ID
4516: from per_all_assignments_f
4517: where assignment_id = p_asg_id
4518: and l_hire_date between effective_start_date and effective_end_date;
4519:
4520: cursor csr_get_asg_type_id (p_asg_id number)is

Line 4522: from per_all_assignments_f

4518: and l_hire_date between effective_start_date and effective_end_date;
4519:
4520: cursor csr_get_asg_type_id (p_asg_id number)is
4521: select assignment_status_type_id
4522: from per_all_assignments_f
4523: where assignment_id = p_asg_id
4524: and l_hire_date between effective_start_date and effective_end_date;
4525:
4526: l_aplasg_vacancy_id number ;

Line 4541: select 'Y' from per_all_assignments_f

4537: l_new_application_id number;
4538: l_yes_backtoback varchar2(1) := 'N';
4539:
4540: cursor chk_future_changes(p_assignment_id number) is
4541: select 'Y' from per_all_assignments_f
4542: where person_id = p_person_id
4543: and assignment_id = p_assignment_id
4544: and effective_start_date >= p_hire_date;
4545:

Line 4558: from per_all_assignments_f

4554: and date_received = p_date_end +1;
4555:
4556: cursor fut_asg_rec is
4557: select assignment_id, effective_start_date, effective_end_date
4558: from per_all_assignments_f
4559: where person_id = p_person_id
4560: and assignment_type = 'A'
4561: and effective_start_date > l_hire_date
4562: and application_id = l_application_id

Line 6559: from per_all_assignments_f

6555: l_fpt_hire_flag :='Y';
6556:
6557: -- retrieve the max end date of the ASG to update the APLN date_end
6558: select max(effective_end_date) into l_apl_end_date
6559: from per_all_assignments_f
6560: where person_id = p_person_id
6561: and assignment_id = apl.assignment_id
6562: and assignment_type = 'A';
6563:

Line 6606: update per_all_assignments_f

6602:
6603: close chk_apl_exists;
6604:
6605: -- update the ASG with the correct APLN ID
6606: update per_all_assignments_f
6607: set application_id = l_cur_apl_id
6608: where person_id = p_person_id
6609: and assignment_id = apl.assignment_id
6610: and effective_start_date = apl.effective_start_date