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.PAY_FR_PTO_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 83: ,per_all_assignments_f asg

79: ,pee.effective_start_date effective_start_date
80: ,asg.payroll_id payroll_id
81: from pay_accrual_plans pap
82: ,pay_element_entries_f pee
83: ,per_all_assignments_f asg
84: where pap.business_group_id + 0 = p_business_group_id
85: and asg.assignment_id = p_assignment_id
86: and p_date_earned between asg.effective_start_date and asg.effective_end_date
87: and pee.element_link_id in (select element_link_id

Line 97: ,PER_ALL_ASSIGNMENTS_F ASG

93:
94: cursor csr_check_for_termination is
95: select null
96: from per_periods_of_service pds
97: ,PER_ALL_ASSIGNMENTS_F ASG
98: where pds.period_of_service_id = asg.period_of_service_id
99: and asg.assignment_id = p_assignment_id
100: and pds.actual_termination_date
101: between asg.effective_start_date and asg.effective_end_Date

Line 589: ,PER_ALL_ASSIGNMENTS_F ASG

585: --
586: cursor csr_check_for_termination is
587: select null
588: from per_periods_of_service pds
589: ,PER_ALL_ASSIGNMENTS_F ASG
590: where pds.period_of_service_id = asg.period_of_service_id
591: and asg.assignment_id = p_assignment_id
592: and pds.actual_termination_date
593: between asg.effective_start_date and asg.effective_end_Date

Line 2245: from per_all_assignments_f

2241: --
2242: -- Changed and renamed cursor c_payroll_id for bug 2662236
2243: CURSOR csr_asg_details (p_assignment_id number, p_effective_date date) is
2244: select payroll_id, assignment_number
2245: from per_all_assignments_f
2246: where assignment_id = p_assignment_id
2247: and (p_effective_date between effective_start_date and effective_end_date);
2248: --
2249: -- Cursor to get the last effective end date of the assignment

Line 2254: from per_all_assignments_f

2250: -- so that terminated employees can be evaluated.
2251: --
2252: CURSOR c_get_asg_end_date (p_assignment_id number) is
2253: select max(effective_end_date)
2254: from per_all_assignments_f
2255: where assignment_id = p_assignment_id;
2256: --
2257: -- Defining cursor selecting hiredate
2258: Cursor csr_assg_hiredate(c_assignment_id number,

Line 2261: From per_all_assignments_f pasg,

2257: -- Defining cursor selecting hiredate
2258: Cursor csr_assg_hiredate(c_assignment_id number,
2259: c_accrual_date date) is
2260: Select ppos.date_start
2261: From per_all_assignments_f pasg,
2262: per_periods_of_service ppos
2263: Where ppos.period_of_service_id = pasg.period_of_service_id
2264: and pasg.assignment_id = c_assignment_id
2265: and c_accrual_date between pasg.effective_start_date

Line 2272: l_assignment_number per_all_assignments_f.assignment_number%TYPE;

2268: -- Local Variables
2269: l_accrual_plan_id Number := p_plan_id;
2270: l_accrual_start_date Date; /* plan year start date */
2271: l_accrual_end_date Date; /* plan year end date */
2272: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
2273:
2274: l_unused_date Date;
2275: l_payroll_id number;
2276: l_max_asg_end_date date;

Line 3826: ,per_all_assignments_f asg

3822: select count(distinct(d.person_id))
3823: from per_all_people_f d
3824: ,per_all_people_f p
3825: ,per_contact_relationships pcr
3826: ,per_all_assignments_f asg
3827: where asg.assignment_id = P_assignment_id
3828: and asg.business_group_id = p_business_Group_id
3829: and asg.person_id = p.person_id
3830: and trunc(sysdate) between asg.effective_start_date and asg.effective_end_date

Line 5013: ,per_all_assignments_f assign

5009: ,target.org_information5
5010: ,target.org_information6
5011: ,target.org_information7
5012: from hr_organization_information target
5013: ,per_all_assignments_f assign
5014: WHERE p_date_earned BETWEEN assign.effective_start_date AND assign.effective_end_date
5015: AND assign.assignment_id = p_assignment_id
5016: AND assign.establishment_id = target.organization_id
5017: AND target.org_information_context = 'FR_ESTAB_ACCRUAL_RATE'

Line 5034: ,per_all_assignments_f assign

5030: ,target.org_information7
5031: from hr_organization_units comp
5032: ,hr_organization_information target
5033: ,hr_organization_information estab
5034: ,per_all_assignments_f assign
5035: WHERE p_date_earned BETWEEN assign.effective_start_date AND assign.effective_end_date
5036: AND assign.assignment_id = p_assignment_id
5037: AND assign.establishment_id = estab.organization_id
5038: AND target.organization_id = comp.organization_id

Line 5675: from per_all_assignments_f asg,

5671: --
5672: l_valid varchar2(10);
5673: cursor csr_find_match is
5674: select 'TRUE'
5675: from per_all_assignments_f asg,
5676: per_contracts_f pcf
5677: where p_date_earned >= asg.effective_start_date
5678: and p_assignment_id = asg.assignment_id
5679: and asg.contract_id = pcf.contract_id

Line 5709: from per_all_assignments_f asg,

5705: l_contract_status per_contracts_f.status%TYPE;
5706: --
5707: cursor csr_get_contract_details is
5708: select pcf.contract_id, pcf.status
5709: from per_all_assignments_f asg,
5710: per_contracts_f pcf
5711: where p_assignment_id = asg.assignment_id
5712: and asg.contract_id = pcf.contract_id
5713: and p_date_earned >= asg.effective_start_date

Line 6003: ,per_all_assignments_f pasg

5999: ,c_end_date date) is
6000: select nvl(sum(pevm.screen_entry_value),0)
6001: from pay_element_entry_values_f pevm
6002: ,pay_element_entries_f pee
6003: ,per_all_assignments_f pasg
6004: where pevm.input_value_id = c_type_m_iv_id
6005: and pee.element_entry_id = pevm.element_entry_id
6006: and pevm.effective_start_date between c_start_date and c_end_date
6007: and pee.effective_start_date between c_start_date and c_end_date

Line 6081: cursor csr_min_effect_start_date(c_assignment_id per_all_assignments_f.assignment_id%type) is

6077: p_contract_end_date out nocopy date,
6078: p_contract_category out nocopy varchar2)
6079: return number is
6080:
6081: cursor csr_min_effect_start_date(c_assignment_id per_all_assignments_f.assignment_id%type) is
6082: select min(effective_start_date)as min_effective_start_date
6083: from per_all_assignments_f
6084: where assignment_id=c_assignment_id;
6085:

Line 6083: from per_all_assignments_f

6079: return number is
6080:
6081: cursor csr_min_effect_start_date(c_assignment_id per_all_assignments_f.assignment_id%type) is
6082: select min(effective_start_date)as min_effective_start_date
6083: from per_all_assignments_f
6084: where assignment_id=c_assignment_id;
6085:
6086: cursor csr_fnd_contract_id(c_assignment_id per_all_assignments_f.assignment_id%type,
6087: c_min_effective_start_date per_all_assignments_f.effective_start_date%TYPE) is

Line 6086: cursor csr_fnd_contract_id(c_assignment_id per_all_assignments_f.assignment_id%type,

6082: select min(effective_start_date)as min_effective_start_date
6083: from per_all_assignments_f
6084: where assignment_id=c_assignment_id;
6085:
6086: cursor csr_fnd_contract_id(c_assignment_id per_all_assignments_f.assignment_id%type,
6087: c_min_effective_start_date per_all_assignments_f.effective_start_date%TYPE) is
6088: select contract_id,effective_end_date,effective_start_date
6089: from per_all_assignments_f
6090: where c_min_effective_start_date between effective_start_date and effective_end_date

Line 6087: c_min_effective_start_date per_all_assignments_f.effective_start_date%TYPE) is

6083: from per_all_assignments_f
6084: where assignment_id=c_assignment_id;
6085:
6086: cursor csr_fnd_contract_id(c_assignment_id per_all_assignments_f.assignment_id%type,
6087: c_min_effective_start_date per_all_assignments_f.effective_start_date%TYPE) is
6088: select contract_id,effective_end_date,effective_start_date
6089: from per_all_assignments_f
6090: where c_min_effective_start_date between effective_start_date and effective_end_date
6091: and assignment_id=c_assignment_id ;

Line 6089: from per_all_assignments_f

6085:
6086: cursor csr_fnd_contract_id(c_assignment_id per_all_assignments_f.assignment_id%type,
6087: c_min_effective_start_date per_all_assignments_f.effective_start_date%TYPE) is
6088: select contract_id,effective_end_date,effective_start_date
6089: from per_all_assignments_f
6090: where c_min_effective_start_date between effective_start_date and effective_end_date
6091: and assignment_id=c_assignment_id ;
6092:
6093: -- Added new cursors for bugs 4099667 and 4103779.

Line 6095: cursor csr_contr_change_catg(c_contract_id per_all_assignments_f.contract_id%TYPE) is

6091: and assignment_id=c_assignment_id ;
6092:
6093: -- Added new cursors for bugs 4099667 and 4103779.
6094: -- Modified cursor to find contract category
6095: cursor csr_contr_change_catg(c_contract_id per_all_assignments_f.contract_id%TYPE) is
6096: select effective_start_date, ctr_information2 con_catg
6097: from per_contracts_f
6098: where contract_id=c_contract_id
6099: and ctr_information_category = 'FR';

Line 6101: cursor csr_contr_max_end(c_contract_id per_all_assignments_f.contract_id%TYPE) is

6097: from per_contracts_f
6098: where contract_id=c_contract_id
6099: and ctr_information_category = 'FR';
6100:
6101: cursor csr_contr_max_end(c_contract_id per_all_assignments_f.contract_id%TYPE) is
6102: select max(effective_end_date)
6103: from per_contracts_f contr
6104: where contract_id=c_contract_id;
6105:

Line 6111: l_min_effective_start_date per_all_assignments_f.effective_start_date%TYPE;

6107: l_csr_fnd_contract_id csr_fnd_contract_id%rowtype;
6108: l_con_start_date date;
6109: l_con_end_date date;
6110: l_con_category varchar2(50);
6111: l_min_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
6112: l_loop_count number;
6113:
6114:
6115: begin

Line 6173: from per_all_assignments_f paf

6169: end if;
6170: --
6171: IF(p_contract_start_date IS NULL) THEN
6172: select min(effective_end_date),min(effective_start_date) INTO p_contract_end_date,p_contract_start_date
6173: from per_all_assignments_f paf
6174: where paf.assignment_id=assignment_id ;
6175: RETURN 1;
6176: END IF;
6177: return 0;

Line 6202: from per_all_assignments_f asg,

6198: Cursor csr_get_time_catg is
6199: Select decode(con.ctr_information12,'HOUR', con.ctr_information13, asg.frequency) frequency,
6200: decode(con.ctr_information12,'HOUR', fnd_number.canonical_to_number(con.ctr_information11), asg.normal_hours) hours,
6201: substr(hruserdt.get_table_value(p_business_group_id, 'FR_CIPDZ', 'CIPDZ',nvl(asg.employment_category,'FR'),p_effective_date),1,1) cipdz_catg
6202: from per_all_assignments_f asg,
6203: per_contracts_f con
6204: where asg.assignment_id = p_assignment_id
6205: and asg.business_group_id = p_business_group_id
6206: and p_effective_date between