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

Line 40: per_all_assignments_f aaf

36: cursor csr_last_dt is
37: Select NVL( max( tp.end_date), p_start_date )
38: From per_time_periods tp,
39: pay_payroll_actions ppa,
40: per_all_assignments_f aaf
41: Where aaf.assignment_id = p_assignment_id
42: and (aaf.effective_end_date >= p_start_date and aaf.effective_start_date <= p_end_date)
43: and ppa.payroll_id = aaf.payroll_id
44: and (ppa.date_earned between tp.start_date and tp.end_date )

Line 57: per_all_assignments_f paf,

53: */
54: cursor csr_last_dt is
55: Select NVL( tp.end_date, p_start_date )
56: from pay_assignment_actions paa,
57: per_all_assignments_f paf,
58: pay_payroll_actions ppa,
59: pay_action_classifications pac,
60: per_time_periods tp
61: where paf.assignment_id = p_assignment_id

Line 384: From per_all_assignments_f

380: is
381: --
382: Cursor csr_assg is
383: Select null
384: From per_all_assignments_f
385: Where assignment_id = p_assignment_id;
386: --
387: l_dummy varchar2(1);
388: l_proc varchar2(72) := g_package ||'Validate_assignment';

Line 724: from per_all_assignments_f asg,

720: AND (p_period_end_dt BETWEEN abv.effective_start_date AND
721: abv.effective_end_date)
722: AND abv.assignment_id =
723: (select assignment_id
724: from per_all_assignments_f asg,
725: per_assignment_status_types ast
726: where asg.assignment_id = p_assignment_id
727: AND asg.assignment_type = 'E'
728: AND (p_period_end_dt BETWEEN asg.effective_start_date AND

Line 1440: -- Per_all_assignments_f is a date-tracked table. There may be more than

1436: p_actuals_end_date in date,
1437: p_last_payroll_dt out nocopy date)
1438: RETURN number is
1439: --
1440: -- Per_all_assignments_f is a date-tracked table. There may be more than
1441: -- one record that is effective in the actuals calculation period
1442: -- with different payrolls.
1443: --
1444: Cursor csr_assg is

Line 1450: From per_all_assignments_f ASSG

1446: ASSG.payroll_id,
1447: ASSG.business_group_id,
1448: ASSG.effective_start_date,
1449: ASSG.effective_end_date
1450: From per_all_assignments_f ASSG
1451: Where ASSG.assignment_id = p_assignment_id
1452: AND ASSG.effective_end_date >= p_actuals_start_date
1453: AND ASSG.effective_start_date <= p_actuals_end_date ;
1454: --

Line 1455: l_assignment_id per_all_assignments_f.assignment_id%type;

1451: Where ASSG.assignment_id = p_assignment_id
1452: AND ASSG.effective_end_date >= p_actuals_start_date
1453: AND ASSG.effective_start_date <= p_actuals_end_date ;
1454: --
1455: l_assignment_id per_all_assignments_f.assignment_id%type;
1456: l_effective_start_date per_all_assignments_f.effective_start_date%type;
1457: l_effective_end_date per_all_assignments_f.effective_end_date%type;
1458: l_payroll_id per_all_assignments_f.payroll_id%type;
1459: l_business_group_id number;

Line 1456: l_effective_start_date per_all_assignments_f.effective_start_date%type;

1452: AND ASSG.effective_end_date >= p_actuals_start_date
1453: AND ASSG.effective_start_date <= p_actuals_end_date ;
1454: --
1455: l_assignment_id per_all_assignments_f.assignment_id%type;
1456: l_effective_start_date per_all_assignments_f.effective_start_date%type;
1457: l_effective_end_date per_all_assignments_f.effective_end_date%type;
1458: l_payroll_id per_all_assignments_f.payroll_id%type;
1459: l_business_group_id number;
1460: l_legislation_code per_business_groups.legislation_code%type;

Line 1457: l_effective_end_date per_all_assignments_f.effective_end_date%type;

1453: AND ASSG.effective_start_date <= p_actuals_end_date ;
1454: --
1455: l_assignment_id per_all_assignments_f.assignment_id%type;
1456: l_effective_start_date per_all_assignments_f.effective_start_date%type;
1457: l_effective_end_date per_all_assignments_f.effective_end_date%type;
1458: l_payroll_id per_all_assignments_f.payroll_id%type;
1459: l_business_group_id number;
1460: l_legislation_code per_business_groups.legislation_code%type;
1461: --

Line 1458: l_payroll_id per_all_assignments_f.payroll_id%type;

1454: --
1455: l_assignment_id per_all_assignments_f.assignment_id%type;
1456: l_effective_start_date per_all_assignments_f.effective_start_date%type;
1457: l_effective_end_date per_all_assignments_f.effective_end_date%type;
1458: l_payroll_id per_all_assignments_f.payroll_id%type;
1459: l_business_group_id number;
1460: l_legislation_code per_business_groups.legislation_code%type;
1461: --
1462: l_assignment_actuals number;

Line 1931: From per_all_assignments_f ASSG

1927: --
1928: --
1929: CURSOR csr_pos_assg is
1930: Select distinct ASSG.assignment_id
1931: From per_all_assignments_f ASSG
1932: Where ASSG.position_id = p_position_id
1933: AND ASSG.effective_end_date >= p_start_date
1934: AND ASSG.effective_start_date <= p_end_date;
1935: --

Line 1938: l_assignment_id per_all_assignments_f.assignment_id%type;

1934: AND ASSG.effective_start_date <= p_end_date;
1935: --
1936: l_position_id pqh_budget_details.position_id%type;
1937: l_position_name hr_all_positions_f.name%type := NULL;
1938: l_assignment_id per_all_assignments_f.assignment_id%type;
1939: l_last_actuals_date per_time_periods.end_date%type;
1940: --
1941: l_budget_id pqh_budgets.budget_id%type := NULL;
1942: --

Line 2129: from per_all_assignments_f

2125:
2126: cursor c_assg is
2127: select effective_start_date, effective_end_date,frequency, normal_hours, time_normal_start, time_normal_finish,
2128: position_id,organization_id,business_group_id
2129: from per_all_assignments_f
2130: where p_assignment_id = assignment_id
2131: and effective_start_date = p_asg_start_date;
2132:
2133: l_frequency per_all_assignments_f.frequency%Type;

Line 2133: l_frequency per_all_assignments_f.frequency%Type;

2129: from per_all_assignments_f
2130: where p_assignment_id = assignment_id
2131: and effective_start_date = p_asg_start_date;
2132:
2133: l_frequency per_all_assignments_f.frequency%Type;
2134: l_normal_hours per_all_assignments_f.normal_hours%Type;
2135: l_assignment_id per_all_assignments_f.assignment_id%Type;
2136: l_bg_normal_day_hours per_all_assignments_f.normal_hours%Type;
2137: l_normal_day_hours per_all_assignments_f.normal_hours%Type;

Line 2134: l_normal_hours per_all_assignments_f.normal_hours%Type;

2130: where p_assignment_id = assignment_id
2131: and effective_start_date = p_asg_start_date;
2132:
2133: l_frequency per_all_assignments_f.frequency%Type;
2134: l_normal_hours per_all_assignments_f.normal_hours%Type;
2135: l_assignment_id per_all_assignments_f.assignment_id%Type;
2136: l_bg_normal_day_hours per_all_assignments_f.normal_hours%Type;
2137: l_normal_day_hours per_all_assignments_f.normal_hours%Type;
2138: l_actual_start_date date;

Line 2135: l_assignment_id per_all_assignments_f.assignment_id%Type;

2131: and effective_start_date = p_asg_start_date;
2132:
2133: l_frequency per_all_assignments_f.frequency%Type;
2134: l_normal_hours per_all_assignments_f.normal_hours%Type;
2135: l_assignment_id per_all_assignments_f.assignment_id%Type;
2136: l_bg_normal_day_hours per_all_assignments_f.normal_hours%Type;
2137: l_normal_day_hours per_all_assignments_f.normal_hours%Type;
2138: l_actual_start_date date;
2139: l_actual_end_date date;

Line 2136: l_bg_normal_day_hours per_all_assignments_f.normal_hours%Type;

2132:
2133: l_frequency per_all_assignments_f.frequency%Type;
2134: l_normal_hours per_all_assignments_f.normal_hours%Type;
2135: l_assignment_id per_all_assignments_f.assignment_id%Type;
2136: l_bg_normal_day_hours per_all_assignments_f.normal_hours%Type;
2137: l_normal_day_hours per_all_assignments_f.normal_hours%Type;
2138: l_actual_start_date date;
2139: l_actual_end_date date;
2140: l_start_date date;

Line 2137: l_normal_day_hours per_all_assignments_f.normal_hours%Type;

2133: l_frequency per_all_assignments_f.frequency%Type;
2134: l_normal_hours per_all_assignments_f.normal_hours%Type;
2135: l_assignment_id per_all_assignments_f.assignment_id%Type;
2136: l_bg_normal_day_hours per_all_assignments_f.normal_hours%Type;
2137: l_normal_day_hours per_all_assignments_f.normal_hours%Type;
2138: l_actual_start_date date;
2139: l_actual_end_date date;
2140: l_start_date date;
2141: l_end_date date;

Line 2243: from per_all_assignments_f

2239: -- if organization_id is passed, index will be used
2240: --
2241: cursor c_org_assg is
2242: select assignment_id, effective_start_date
2243: from per_all_assignments_f
2244: where organization_id = p_organization_id
2245: and business_group_id = p_business_grp_id
2246: and effective_end_date >= p_start_date
2247: and effective_start_date <= p_end_date ;

Line 2251: from per_all_assignments_f

2247: and effective_start_date <= p_end_date ;
2248:
2249: cursor c_position_assg is
2250: select assignment_id, effective_start_date
2251: from per_all_assignments_f
2252: where p_position_id = position_id
2253: and effective_end_date >= p_start_date
2254: and effective_start_date <= p_end_date ;
2255:

Line 2258: from per_all_assignments_f

2254: and effective_start_date <= p_end_date ;
2255:
2256: cursor c_job_assg is
2257: select assignment_id, effective_start_date
2258: from per_all_assignments_f
2259: where p_job_id = job_id
2260: and effective_end_date >= p_start_date
2261: and effective_start_date <= p_end_date ;
2262:

Line 2265: from per_all_assignments_f

2261: and effective_start_date <= p_end_date ;
2262:
2263: cursor c_grade_assg is
2264: select assignment_id, effective_start_date
2265: from per_all_assignments_f
2266: where p_grade_id = grade_id
2267: and effective_end_date >= p_start_date
2268: and effective_start_date <= p_end_date ;
2269:

Line 2337: From per_all_assignments_f ASSG

2333: --
2334: --
2335: CURSOR csr_pos_assg is
2336: Select distinct ASSG.assignment_id
2337: From per_all_assignments_f ASSG
2338: Where ASSG.position_id = p_position_id
2339: AND ASSG.effective_end_date >= p_start_date
2340: AND ASSG.effective_start_date <= p_end_date
2341: AND ASSG.assignment_id <> p_ex_assignment_id;

Line 2345: l_assignment_id per_all_assignments_f.assignment_id%type;

2341: AND ASSG.assignment_id <> p_ex_assignment_id;
2342: --
2343: l_position_id pqh_budget_details.position_id%type;
2344: l_position_name hr_all_positions_f.name%type := NULL;
2345: l_assignment_id per_all_assignments_f.assignment_id%type;
2346: l_last_actuals_date per_time_periods.end_date%type;
2347: --
2348: l_budget_id pqh_budgets.budget_id%type := NULL;
2349: --

Line 2588: From per_all_assignments_f ASSG

2584: --
2585: --
2586: CURSOR csr_pos_assg (p_business_group_id number) is
2587: Select distinct ASSG.assignment_id
2588: From per_all_assignments_f ASSG
2589: Where ASSG.position_id = p_entity_id
2590: and business_group_id = p_business_group_id
2591: AND ASSG.effective_end_date >= p_start_date
2592: AND ASSG.effective_start_date <= p_end_date;

Line 2596: From per_all_assignments_f ASSG

2592: AND ASSG.effective_start_date <= p_end_date;
2593: --
2594: CURSOR csr_job_assg(p_business_group_id number) is
2595: Select distinct ASSG.assignment_id
2596: From per_all_assignments_f ASSG
2597: Where ASSG.job_id = p_entity_id
2598: and business_group_id = p_business_group_id
2599: AND ASSG.effective_end_date >= p_start_date
2600: AND ASSG.effective_start_date <= p_end_date;

Line 2604: From per_all_assignments_f ASSG

2600: AND ASSG.effective_start_date <= p_end_date;
2601: --
2602: CURSOR csr_grade_assg(p_business_group_id number) is
2603: Select distinct ASSG.assignment_id
2604: From per_all_assignments_f ASSG
2605: Where ASSG.grade_id = p_entity_id
2606: and business_group_id = p_business_group_id
2607: AND ASSG.effective_end_date >= p_start_date
2608: AND ASSG.effective_start_date <= p_end_date ;

Line 2612: From per_all_assignments_f ASSG

2608: AND ASSG.effective_start_date <= p_end_date ;
2609: --
2610: CURSOR csr_org_assg(p_business_group_id number) is
2611: Select distinct ASSG.assignment_id
2612: From per_all_assignments_f ASSG
2613: Where ASSG.organization_id = p_entity_id
2614: and business_group_id = p_business_group_id
2615: AND ASSG.effective_end_date >= p_start_date
2616: AND ASSG.effective_start_date <= p_end_date;

Line 2619: l_assignment_id per_all_assignments_f.assignment_id%type;

2615: AND ASSG.effective_end_date >= p_start_date
2616: AND ASSG.effective_start_date <= p_end_date;
2617: --
2618:
2619: l_assignment_id per_all_assignments_f.assignment_id%type;
2620: l_business_group_id per_all_assignments_f.business_group_id%type;
2621: l_last_actuals_date per_time_periods.end_date%type;
2622: --
2623: l_budget_id pqh_budgets.budget_id%type := NULL;

Line 2620: l_business_group_id per_all_assignments_f.business_group_id%type;

2616: AND ASSG.effective_start_date <= p_end_date;
2617: --
2618:
2619: l_assignment_id per_all_assignments_f.assignment_id%type;
2620: l_business_group_id per_all_assignments_f.business_group_id%type;
2621: l_last_actuals_date per_time_periods.end_date%type;
2622: --
2623: l_budget_id pqh_budgets.budget_id%type := NULL;
2624: --

Line 3837: from per_all_assignments_f assg

3833: -- Cursors to fetch assignments
3834: --
3835: cursor csr_position_assg is
3836: select distinct assg.assignment_id
3837: from per_all_assignments_f assg
3838: where business_group_id = p_business_group_id
3839: and p_position_id = assg.position_id
3840: and assg.effective_end_date >= p_start_date
3841: and assg.effective_start_date <= p_end_date;

Line 3845: from per_all_assignments_f assg

3841: and assg.effective_start_date <= p_end_date;
3842: --
3843: cursor csr_job_assg is
3844: select distinct assg.assignment_id
3845: from per_all_assignments_f assg
3846: where business_group_id = p_business_group_id
3847: and p_job_id = assg.job_id
3848: and assg.effective_end_date >= p_start_date
3849: and assg.effective_start_date <= p_end_date;

Line 3853: from per_all_assignments_f assg

3849: and assg.effective_start_date <= p_end_date;
3850: --
3851: cursor csr_org_assg is
3852: select distinct assg.assignment_id
3853: from per_all_assignments_f assg
3854: where p_organization_id = assg.organization_id
3855: and business_group_id = p_business_group_id
3856: and assg.effective_end_date >= p_start_date
3857: and assg.effective_start_date <= p_end_date;

Line 3861: from per_all_assignments_f assg

3857: and assg.effective_start_date <= p_end_date;
3858: --
3859: cursor csr_grade_assg is
3860: select distinct assg.assignment_id
3861: from per_all_assignments_f assg
3862: where business_group_id = p_business_group_id
3863: and p_grade_id = assg.grade_id
3864: and assg.effective_end_date >= p_start_date
3865: and assg.effective_start_date <= p_end_date;

Line 3869: l_assignment_id per_all_assignments_f.assignment_id%type;

3865: and assg.effective_start_date <= p_end_date;
3866: --
3867: l_position_id pqh_budget_details.position_id%type;
3868: l_position_name hr_all_positions_f.name%type := NULL;
3869: l_assignment_id per_all_assignments_f.assignment_id%type;
3870: l_last_actuals_date per_time_periods.end_date%type;
3871: --
3872: l_budget_id pqh_budgets.budget_id%type := NULL;
3873: --

Line 4065: (select distinct assignment_id, payroll_id from per_all_assignments_f assg

4061: ) is
4062:
4063: Select sum(pc.costed_value)
4064: From
4065: (select distinct assignment_id, payroll_id from per_all_assignments_f assg
4066: where ASSG.effective_end_date >= p_actuals_start_date
4067: and ASSG.effective_start_date <= p_actuals_end_date
4068: AND assg.position_id = p_position_id
4069: -- and assg.assignment_id <> p_ex_assignment_id

Line 4121: (select distinct assignment_id, payroll_id from per_all_assignments_f assg

4117: p_cl_id_1 number,
4118: p_cl_id_2 number) is
4119: Select sum(pc.costed_value)
4120: From
4121: (select distinct assignment_id, payroll_id from per_all_assignments_f assg
4122: where ASSG.effective_end_date >= p_actuals_start_date
4123: and ASSG.effective_start_date <= p_actuals_end_date
4124: AND assg.position_id = p_position_id
4125: -- and assg.assignment_id <> p_ex_assignment_id