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_QPQ_API dependencies on PER_ASSIGNMENTS_F

Line 411: , per_assignments_f asg

407: --
408: cursor pay_asg is
409: select 'Y'
410: from fnd_sessions ses
411: , per_assignments_f asg
412: where ses.session_id = userenv('SESSIONID')
413: and ses.effective_date between asg.effective_start_date
414: and asg.effective_end_date
415: and asg.payroll_id is not null

Line 460: from per_assignments_f asg

456: v_argument varchar2(30);
457: --
458: cursor cur_dat (v_assignment_id number, v_new_date date) is
459: select 'Y'
460: from per_assignments_f asg
461: where asg.assignment_id = v_assignment_id
462: and asg.payroll_id is not null
463: and v_new_date between asg.effective_start_date
464: and asg.effective_end_date;

Line 541: from per_assignments_f

537: v_proc varchar2(72) := g_package||'chk_assignment';
538: --
539: cursor sel_asg is
540: select 'Y'
541: from per_assignments_f
542: where assignment_id = p_assignment_id
543: and business_group_id + 0 = p_business_group_id
544: and p_effective_date between effective_start_date
545: and effective_end_date;

Line 821: , per_assignments_f a

817: select p.start_date
818: , p.end_date
819: , a.payroll_id
820: from per_time_periods p
821: , per_assignments_f a
822: where a.assignment_id = p_assignment_id
823: and p_effective_date between a.effective_start_date
824: and a.effective_end_date
825: and p.payroll_id = a.payroll_id

Line 837: from per_assignments_f a

833: ) is
834: select a.effective_start_date
835: , a.effective_end_date
836: , a.payroll_id
837: from per_assignments_f a
838: where a.assignment_id = p_assignment_id
839: and a.effective_end_date >= v_period_start
840: and a.effective_start_date <= v_period_end
841: order by a.effective_start_date;

Line 854: v_cur_payroll_id per_assignments_f.payroll_id%TYPE;

850: -- p_effective_date.
851: v_period_end_date date;
852: --
853: -- The assignment's payroll as of p_effective_date.
854: v_cur_payroll_id per_assignments_f.payroll_id%TYPE;
855: --
856: -- Working value for the date earned. The best value so far given the
857: -- the processed records.
858: v_wrk_date date := null;

Line 998: from per_assignments_f asg

994: -- Used to find out if the assingment is on a payroll as p_effective_date
995: --
996: cursor sel_pay is
997: select asg.payroll_id
998: from per_assignments_f asg
999: where /* Payroll as of effective date */
1000: asg.assignment_id = p_assignment_id
1001: and asg.payroll_id is not null
1002: and p_effective_date between asg.effective_start_date

Line 1198: from per_assignments_f asg

1194: v_rule_mode pay_legislation_rules.rule_mode%type;
1195: --
1196: cursor sel_pay is
1197: select asg.payroll_id
1198: from per_assignments_f asg
1199: where /* Payroll as of date_earned */
1200: asg.assignment_id = p_assignment_id
1201: and asg.payroll_id is not null
1202: and p_date_earned between asg.effective_start_date

Line 1335: from per_assignments_f asg1

1331: v_proc varchar2(72) := g_package||'chk_eff_earned_payroll';
1332: --
1333: cursor sel_same is
1334: select 'Y'
1335: from per_assignments_f asg1
1336: , per_assignments_f asg2
1337: where /* Payroll as of date_earned */
1338: asg1.assignment_id = p_assignment_id
1339: and p_date_earned between asg1.effective_start_date

Line 1336: , per_assignments_f asg2

1332: --
1333: cursor sel_same is
1334: select 'Y'
1335: from per_assignments_f asg1
1336: , per_assignments_f asg2
1337: where /* Payroll as of date_earned */
1338: asg1.assignment_id = p_assignment_id
1339: and p_date_earned between asg1.effective_start_date
1340: and asg1.effective_end_date

Line 3859: select /+ ORDERED INDEX(asg PER_ASSIGNMENTS_F_PK) /

3855: from fnd_sessions ses
3856: where ses.session_id = userenv('sessionid');
3857: --
3858: cursor csr_payroll (v_cur_date date) is
3859: select /*+ ORDERED INDEX(asg PER_ASSIGNMENTS_F_PK) */
3860: asg.payroll_id
3861: , pro.consolidation_set_id
3862: , con.consolidation_set_name
3863: , bus.legislation_code

Line 3869: from per_assignments_f asg

3865: , hr_general.decode_lookup('ASSIGNMENT_ACTION_STATUS', 'M')
3866: , hr_general.decode_lookup('ASSIGNMENT_ACTION_STATUS', 'C')
3867: , hr_general.decode_lookup('ASSIGNMENT_ACTION_STATUS', 'E')
3868: , hr_general.decode_lookup('ACTION_TYPE', 'Q')
3869: from per_assignments_f asg
3870: , pay_payrolls_f pro
3871: , pay_consolidation_sets con
3872: , per_business_groups_perf bus
3873: where /* Assignment's Payroll details */

Line 3902: v_payroll_id per_assignments_f.payroll_id%TYPE;

3898: -- The assignment's business group legislation_code:
3899: v_legislation_code per_business_groups.legislation_code%TYPE;
3900: --
3901: -- The assignment's payroll as of the session effective or trunc(sysdate).
3902: v_payroll_id per_assignments_f.payroll_id%TYPE;
3903: --
3904: -- Period name which exists as of v_eff_date.
3905: v_period_name per_time_periods.period_name%TYPE;
3906: --