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_ASSIGNMENT_ACTIONS

Line 34: p_locked_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE,

30: PROCEDURE RUN_ASSACT(
31: -----------------------------------------------------------------------
32: p_errbuf OUT NOCOPY VARCHAR2,
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;

Line 35: p_locking_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE )

31: -----------------------------------------------------------------------
32: p_errbuf OUT NOCOPY VARCHAR2,
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;

Line 40: l_assact_action_status pay_assignment_actions.action_status%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:
44: ----------------------------------------

Line 42: l_assignment_id pay_assignment_actions.assignment_id%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
46: ----------------------------------------

Line 54: pay_assignment_actions paa

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
58: and ppa.action_type in ('R','Q','B','I')

Line 64: p_assignment_id IN pay_assignment_actions.assignment_id%TYPE,

60: --
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,

Line 110: p_locked_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE,

106: --
107: PROCEDURE insert_row(
108: p_errbuf OUT NOCOPY VARCHAR2,
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)

Line 111: p_locking_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE,

107: PROCEDURE insert_row(
108: p_errbuf OUT NOCOPY VARCHAR2,
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

Line 112: p_assignment_id IN pay_assignment_actions.assignment_id%TYPE,

108: p_errbuf OUT NOCOPY VARCHAR2,
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);

Line 306: from pay_assignment_actions paa

302: or action_information_category='JP_PRE_TAX_2')
303: and action_context_type='AAP'
304: and not exists(
305: select NULL
306: from pay_assignment_actions paa
307: where paa.assignment_action_id=pai.action_information1);
308:
309: commit;
310:

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 464: assignment_action_id pay_assignment_actions.assignment_action_id%TYPE);

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:
468: l_assact_tab t_assact_tab;

Line 504: FROM pay_assignment_actions

500: l_payroll_action_id := l_assact_tab(l_count).payroll_action_id;
501:
502: SELECT COUNT(1)
503: INTO l_count1 -- Bug 13772840
504: FROM pay_assignment_actions
505: WHERE payroll_action_id = l_payroll_action_id;
506:
507: IF (l_count1=0) THEN -- Bug 13772840
508: py_rollback_pkg.rollback_payroll_action(

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 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 596: assignment_action_id pay_assignment_actions.assignment_action_id%TYPE);

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:
600: l_assact_tab t_assact_tab;

Line 712: FROM pay_assignment_actions

708: l_payroll_action_id := l_assact_tab(l_count).payroll_action_id;
709:
710: SELECT COUNT(1)
711: INTO l_count1
712: FROM pay_assignment_actions
713: WHERE payroll_action_id = l_payroll_action_id;
714:
715: IF (l_count1=0) THEN
716: py_rollback_pkg.rollback_payroll_action(

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

Line 762: p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE) IS

758: PROCEDURE RUN_SINGLE_ASSACT(
759: -----------------------------------------------------------------------
760: p_errbuf OUT NOCOPY VARCHAR2,
761: p_retcode OUT NOCOPY VARCHAR2,
762: p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE) IS
763:
764: l_count NUMBER;
765:
766: l_errbuf VARCHAR2(255);