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_JP_PRE_TAX_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 37: l_effective_date pay_payroll_actions.effective_date%TYPE;

33: p_retcode OUT NOCOPY VARCHAR2,
34: p_locked_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE,
35: p_locking_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE )
36: IS
37: l_effective_date pay_payroll_actions.effective_date%TYPE;
38: l_value pay_jp_custom_pkg.value_rec;
39: l_business_group_id pay_payroll_actions.business_group_id%TYPE;
40: l_assact_action_status pay_assignment_actions.action_status%TYPE;
41: l_date_earned pay_payroll_actions.date_earned%TYPE;

Line 39: l_business_group_id pay_payroll_actions.business_group_id%TYPE;

35: p_locking_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE )
36: IS
37: l_effective_date pay_payroll_actions.effective_date%TYPE;
38: l_value pay_jp_custom_pkg.value_rec;
39: l_business_group_id pay_payroll_actions.business_group_id%TYPE;
40: l_assact_action_status pay_assignment_actions.action_status%TYPE;
41: l_date_earned pay_payroll_actions.date_earned%TYPE;
42: l_assignment_id pay_assignment_actions.assignment_id%TYPE;
43:

Line 41: l_date_earned pay_payroll_actions.date_earned%TYPE;

37: l_effective_date pay_payroll_actions.effective_date%TYPE;
38: l_value pay_jp_custom_pkg.value_rec;
39: l_business_group_id pay_payroll_actions.business_group_id%TYPE;
40: l_assact_action_status pay_assignment_actions.action_status%TYPE;
41: l_date_earned pay_payroll_actions.date_earned%TYPE;
42: l_assignment_id pay_assignment_actions.assignment_id%TYPE;
43:
44: ----------------------------------------
45: -- Cursor

Line 53: from pay_payroll_actions ppa,

49: paa.action_status ASSACT_ACTION_STATUS,
50: ppa.date_earned,
51: ppa.effective_date,
52: paa.assignment_id
53: from pay_payroll_actions ppa,
54: pay_assignment_actions paa
55: where paa.assignment_action_id=p_locked_assignment_action_id
56: and paa.action_status='C'
57: and ppa.payroll_action_id=paa.payroll_action_id

Line 65: p_effective_date IN pay_payroll_actions.effective_date%TYPE,

61: PROCEDURE get_assignment_details(
62: p_errbuf OUT NOCOPY VARCHAR2,
63: p_retcode OUT NOCOPY VARCHAR2,
64: p_assignment_id IN pay_assignment_actions.assignment_id%TYPE,
65: p_effective_date IN pay_payroll_actions.effective_date%TYPE,
66: p_person_id OUT NOCOPY per_all_assignments_f.person_id%TYPE,
67: p_period_of_service_id OUT NOCOPY per_all_assignments_f.period_of_service_id%TYPE,
68: p_date_start OUT NOCOPY per_periods_of_service.date_start%TYPE,
69: p_leaving_reason OUT NOCOPY per_periods_of_service.leaving_reason%TYPE,

Line 113: p_effective_date IN pay_payroll_actions.effective_date%TYPE,

109: p_retcode OUT NOCOPY VARCHAR2,
110: p_locked_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE,
111: p_locking_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE,
112: p_assignment_id IN pay_assignment_actions.assignment_id%TYPE,
113: p_effective_date IN pay_payroll_actions.effective_date%TYPE,
114: p_value IN pay_jp_custom_pkg.value_rec)
115: IS
116: l_action_status VARCHAR2(1);
117: l_message VARCHAR2(255);

Line 439: p_business_group_id IN pay_payroll_actions.business_group_id%TYPE,

435: PROCEDURE ROLLBACK_ASSACT(
436: -----------------------------------------------------------------------
437: p_errbuf OUT NOCOPY VARCHAR2,
438: p_retcode OUT NOCOPY VARCHAR2,
439: p_business_group_id IN pay_payroll_actions.business_group_id%TYPE,
440: p_payroll_id IN pay_all_payrolls_f.payroll_id%TYPE,
441: p_from_date IN DATE,
442: p_to_date IN DATE) IS
443: --

Line 447: FROM pay_payroll_actions ppa, pay_assignment_actions paa,

443: --
444:
445: CURSOR csr_assact IS
446: SELECT DISTINCT paa1.assignment_action_id, ppa1.payroll_action_id
447: FROM pay_payroll_actions ppa, pay_assignment_actions paa,
448: pay_payroll_actions ppa1, pay_assignment_actions paa1,
449: pay_action_information pai
450: WHERE ppa.business_group_id = p_business_group_id
451: AND ppa.payroll_id = p_payroll_id

Line 448: pay_payroll_actions ppa1, pay_assignment_actions paa1,

444:
445: CURSOR csr_assact IS
446: SELECT DISTINCT paa1.assignment_action_id, ppa1.payroll_action_id
447: FROM pay_payroll_actions ppa, pay_assignment_actions paa,
448: pay_payroll_actions ppa1, pay_assignment_actions paa1,
449: pay_action_information pai
450: WHERE ppa.business_group_id = p_business_group_id
451: AND ppa.payroll_id = p_payroll_id
452: AND ppa.date_earned BETWEEN p_from_date AND p_to_date

Line 463: payroll_action_id pay_payroll_actions.payroll_action_id%TYPE,

459: AND ppa1.business_group_id = p_business_group_id
460: AND ppa1.action_type = 'X';
461:
462: TYPE t_assact_rec IS RECORD(
463: payroll_action_id pay_payroll_actions.payroll_action_id%TYPE,
464: assignment_action_id pay_assignment_actions.assignment_action_id%TYPE);
465:
466: TYPE t_assact_tab IS TABLE OF t_assact_rec INDEX BY BINARY_INTEGER;
467:

Line 470: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;

466: TYPE t_assact_tab IS TABLE OF t_assact_rec INDEX BY BINARY_INTEGER;
467:
468: l_assact_tab t_assact_tab;
469:
470: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
471: l_index NUMBER := 1;
472: l_count NUMBER;
473: l_count1 NUMBER; -- Bug 13772840
474:

Line 526: from pay_assignment_actions paa,pay_payroll_actions ppa

522: WHERE (pai.action_information_category='JP_PRE_TAX_1'
523: OR pai.action_information_category='JP_PRE_TAX_2')
524: AND pai.action_context_type='AAP'
525: AND exists ( select null
526: from pay_assignment_actions paa,pay_payroll_actions ppa
527: where paa.PAYROLL_ACTION_ID = ppa.PAYROLL_ACTION_ID
528: and ppa.business_group_id = p_business_group_id
529: and ppa.date_earned BETWEEN p_from_date AND p_to_date --Bug 14094779
530: and paa.ASSIGNMENT_ACTION_ID = pai.ACTION_INFORMATION1

Line 550: p_business_group_id IN pay_payroll_actions.business_group_id%TYPE,

546: PROCEDURE ROLLBACK_ASSACT_ASGSET(
547: -----------------------------------------------------------------------
548: p_errbuf OUT NOCOPY VARCHAR2,
549: p_retcode OUT NOCOPY VARCHAR2,
550: p_business_group_id IN pay_payroll_actions.business_group_id%TYPE,
551: p_payroll_id IN pay_payroll_actions.business_group_id%TYPE,
552: p_assignment_set_id IN hr_assignment_sets.assignment_set_id%TYPE,
553: p_from_date IN varchar2,
554: p_to_date IN varchar2) IS

Line 551: p_payroll_id IN pay_payroll_actions.business_group_id%TYPE,

547: -----------------------------------------------------------------------
548: p_errbuf OUT NOCOPY VARCHAR2,
549: p_retcode OUT NOCOPY VARCHAR2,
550: p_business_group_id IN pay_payroll_actions.business_group_id%TYPE,
551: p_payroll_id IN pay_payroll_actions.business_group_id%TYPE,
552: p_assignment_set_id IN hr_assignment_sets.assignment_set_id%TYPE,
553: p_from_date IN varchar2,
554: p_to_date IN varchar2) IS
555: --

Line 562: FROM pay_payroll_actions ppa, pay_assignment_actions paa,

558:
559: CURSOR csr_assact(p_assignment_id NUMBER)
560: IS
561: SELECT DISTINCT paa1.assignment_action_id, ppa1.payroll_action_id
562: FROM pay_payroll_actions ppa, pay_assignment_actions paa,
563: pay_payroll_actions ppa1, pay_assignment_actions paa1,
564: pay_action_information pai
565: WHERE ppa.business_group_id = p_business_group_id
566: AND ppa.payroll_id = p_payroll_id

Line 563: pay_payroll_actions ppa1, pay_assignment_actions paa1,

559: CURSOR csr_assact(p_assignment_id NUMBER)
560: IS
561: SELECT DISTINCT paa1.assignment_action_id, ppa1.payroll_action_id
562: FROM pay_payroll_actions ppa, pay_assignment_actions paa,
563: pay_payroll_actions ppa1, pay_assignment_actions paa1,
564: pay_action_information pai
565: WHERE ppa.business_group_id = p_business_group_id
566: AND ppa.payroll_id = p_payroll_id
567: AND ppa.date_earned BETWEEN l_from_date AND l_to_date

Line 595: payroll_action_id pay_payroll_actions.payroll_action_id%TYPE,

591:
592: l_temp_table t_temp_table;
593:
594: TYPE t_assact_rec IS RECORD(
595: payroll_action_id pay_payroll_actions.payroll_action_id%TYPE,
596: assignment_action_id pay_assignment_actions.assignment_action_id%TYPE);
597:
598: TYPE t_assact_tab IS TABLE OF t_assact_rec INDEX BY BINARY_INTEGER;
599:

Line 602: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;

598: TYPE t_assact_tab IS TABLE OF t_assact_rec INDEX BY BINARY_INTEGER;
599:
600: l_assact_tab t_assact_tab;
601:
602: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
603: l_index NUMBER := 1;
604: l_index1 NUMBER;
605: l_count NUMBER;
606: l_count1 NUMBER; -- Bug 13772840

Line 734: from pay_assignment_actions paa,pay_payroll_actions ppa

730: WHERE (pai.action_information_category='JP_PRE_TAX_1'
731: OR pai.action_information_category='JP_PRE_TAX_2')
732: AND pai.action_context_type='AAP'
733: AND exists ( select null
734: from pay_assignment_actions paa,pay_payroll_actions ppa
735: where paa.PAYROLL_ACTION_ID = ppa.PAYROLL_ACTION_ID
736: and ppa.business_group_id = p_business_group_id
737: and ppa.date_earned BETWEEN l_from_date AND l_to_date --Bug 14094779
738: and paa.ASSIGNMENT_ACTION_ID = pai.ACTION_INFORMATION1