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_PL_SII_API dependencies on PER_BUSINESS_GROUPS

Line 341: l_business_group_id per_business_groups.business_group_id%TYPE;

337: --
338: -- Declare cursors and local variables
339: --
340:
341: l_business_group_id per_business_groups.business_group_id%TYPE;
342: l_legislation_code per_business_groups.legislation_code%TYPE;
343: l_contract_category pay_pl_sii_details_f.contract_category%TYPE;
344:
345: l_effective_date date;

Line 342: l_legislation_code per_business_groups.legislation_code%TYPE;

338: -- Declare cursors and local variables
339: --
340:
341: l_business_group_id per_business_groups.business_group_id%TYPE;
342: l_legislation_code per_business_groups.legislation_code%TYPE;
343: l_contract_category pay_pl_sii_details_f.contract_category%TYPE;
344:
345: l_effective_date date;
346: l_effective_start_date date;

Line 357: , per_business_groups_perf bus

353: cursor csr_get_derived_details is
354: select bus.business_group_id
355: , bus.legislation_code
356: from per_all_assignments_f paf
357: , per_business_groups_perf bus
358: where paf.person_id = p_assignment_id
359: and l_effective_date between paf.effective_start_date
360: and paf.effective_end_date
361: and bus.business_group_id = paf.business_group_id;

Line 442: l_business_group_id per_business_groups.business_group_id%TYPE;

438: --
439: -- Declare cursors and local variables
440: --
441:
442: l_business_group_id per_business_groups.business_group_id%TYPE;
443: l_legislation_code per_business_groups.legislation_code%TYPE;
444: l_contract_category pay_pl_sii_details_f.contract_category%TYPE;
445:
446: l_effective_date date;

Line 443: l_legislation_code per_business_groups.legislation_code%TYPE;

439: -- Declare cursors and local variables
440: --
441:
442: l_business_group_id per_business_groups.business_group_id%TYPE;
443: l_legislation_code per_business_groups.legislation_code%TYPE;
444: l_contract_category pay_pl_sii_details_f.contract_category%TYPE;
445:
446: l_effective_date date;
447: l_effective_start_date date;

Line 458: , per_business_groups_perf bus

454: cursor csr_get_derived_details is
455: select bus.business_group_id
456: , bus.legislation_code
457: from per_all_assignments_f paf
458: , per_business_groups_perf bus
459: where paf.person_id = p_assignment_id
460: and l_effective_date between paf.effective_start_date
461: and paf.effective_end_date
462: and bus.business_group_id = paf.business_group_id;

Line 543: l_business_group_id per_business_groups.business_group_id%TYPE;

539: --
540: -- Declare cursors and local variables
541: --
542:
543: l_business_group_id per_business_groups.business_group_id%TYPE;
544: l_legislation_code per_business_groups.legislation_code%TYPE;
545: l_contract_category pay_pl_sii_details_f.contract_category%TYPE;
546:
547: l_effective_date date;

Line 544: l_legislation_code per_business_groups.legislation_code%TYPE;

540: -- Declare cursors and local variables
541: --
542:
543: l_business_group_id per_business_groups.business_group_id%TYPE;
544: l_legislation_code per_business_groups.legislation_code%TYPE;
545: l_contract_category pay_pl_sii_details_f.contract_category%TYPE;
546:
547: l_effective_date date;
548: l_effective_start_date date;

Line 559: , per_business_groups_perf bus

555: cursor csr_get_derived_details is
556: select bus.business_group_id
557: , bus.legislation_code
558: from per_all_assignments_f paf
559: , per_business_groups_perf bus
560: where paf.person_id = p_assignment_id
561: and l_effective_date between paf.effective_start_date
562: and paf.effective_end_date
563: and bus.business_group_id = paf.business_group_id;

Line 646: l_business_group_id per_business_groups.business_group_id%TYPE;

642: --
643: -- Declare cursors and local variables
644: --
645:
646: l_business_group_id per_business_groups.business_group_id%TYPE;
647: l_legislation_code per_business_groups.legislation_code%TYPE;
648:
649: l_effective_date date;
650: l_effective_start_date date;

Line 647: l_legislation_code per_business_groups.legislation_code%TYPE;

643: -- Declare cursors and local variables
644: --
645:
646: l_business_group_id per_business_groups.business_group_id%TYPE;
647: l_legislation_code per_business_groups.legislation_code%TYPE;
648:
649: l_effective_date date;
650: l_effective_start_date date;
651: l_effective_end_date date;

Line 661: , per_business_groups_perf bus

657: cursor csr_get_derived_details is
658: select bus.business_group_id
659: , bus.legislation_code
660: from per_all_people_f papf
661: , per_business_groups_perf bus
662: where papf.person_id = p_person_id
663: and l_effective_date between papf.effective_start_date
664: and papf.effective_end_date
665: and bus.business_group_id = papf.business_group_id;