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 1437: -- Per_all_assignments_f is a date-tracked table. There may be more than

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

Line 1447: From per_all_assignments_f ASSG

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

Line 1452: l_assignment_id per_all_assignments_f.assignment_id%type;

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

Line 1453: l_effective_start_date per_all_assignments_f.effective_start_date%type;

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

Line 1454: l_effective_end_date per_all_assignments_f.effective_end_date%type;

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

Line 1455: l_payroll_id per_all_assignments_f.payroll_id%type;

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

Line 1928: From per_all_assignments_f ASSG

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

Line 1935: l_assignment_id per_all_assignments_f.assignment_id%type;

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

Line 2126: from per_all_assignments_f

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

Line 2130: l_frequency per_all_assignments_f.frequency%Type;

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

Line 2131: l_normal_hours per_all_assignments_f.normal_hours%Type;

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

Line 2132: l_assignment_id per_all_assignments_f.assignment_id%Type;

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

Line 2133: l_bg_normal_day_hours per_all_assignments_f.normal_hours%Type;

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

Line 2134: l_normal_day_hours per_all_assignments_f.normal_hours%Type;

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

Line 2240: from per_all_assignments_f

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

Line 2248: from per_all_assignments_f

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

Line 2255: from per_all_assignments_f

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

Line 2262: from per_all_assignments_f

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

Line 2334: From per_all_assignments_f ASSG

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

Line 2342: l_assignment_id per_all_assignments_f.assignment_id%type;

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

Line 2585: From per_all_assignments_f ASSG

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

Line 2593: From per_all_assignments_f ASSG

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

Line 2601: From per_all_assignments_f ASSG

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

Line 2609: From per_all_assignments_f ASSG

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

Line 2616: l_assignment_id per_all_assignments_f.assignment_id%type;

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

Line 2617: l_business_group_id per_all_assignments_f.business_group_id%type;

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

Line 3834: from per_all_assignments_f assg

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

Line 3842: from per_all_assignments_f assg

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

Line 3850: from per_all_assignments_f assg

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

Line 3858: from per_all_assignments_f assg

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

Line 3866: l_assignment_id per_all_assignments_f.assignment_id%type;

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

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

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

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

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