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

Line 59: gn_arc_payroll_action_id pay_payroll_actions.payroll_action_id%type;

55: gc_report_type CONSTANT VARCHAR2(60) := 'JP_IWHT_ARCH';
56: --
57: -- Global to store package name for tracing.
58: -- Declaration of global variables
59: gn_arc_payroll_action_id pay_payroll_actions.payroll_action_id%type;
60: gn_business_group_id hr_all_organization_units.organization_id%type;
61: gn_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
62: gb_debug BOOLEAN;
63: gd_end_date DATE;

Line 61: gn_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;

57: -- Global to store package name for tracing.
58: -- Declaration of global variables
59: gn_arc_payroll_action_id pay_payroll_actions.payroll_action_id%type;
60: gn_business_group_id hr_all_organization_units.organization_id%type;
61: gn_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
62: gb_debug BOOLEAN;
63: gd_end_date DATE;
64: gd_start_date DATE;
65: gd_effective_date DATE;

Line 70: PROCEDURE range_code ( p_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE

66: gd_ystart_date DATE;
67: gd_yend_date DATE;
68:
69: --
70: PROCEDURE range_code ( p_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE
71: ,p_sql OUT NOCOPY VARCHAR2
72: )
73: --***************************************************************************
74: -- PROCEDURE

Line 115: ' pay_payroll_actions pa' ||

111: -- sql string to SELECT a range of assignments eligible for archival.
112: -------------------------------------------------------------------------
113: p_sql := ' SELECT distinct p.person_id' ||
114: ' FROM per_people_f p,' ||
115: ' pay_payroll_actions pa' ||
116: ' WHERE pa.payroll_action_id = :payroll_action_id' ||
117: ' AND p.business_group_id = pa.business_group_id' ||
118: ' ORDER BY p.person_id';
119: --

Line 130: PROCEDURE initialize ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE )

126: END IF;
127: --
128: END range_code;
129: --
130: PROCEDURE initialize ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE )
131: --*************************************************************************
132: -- PROCEDURE
133: -- initialize
134: --

Line 155: CURSOR lcr_params(p_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)

151: -- INITIALIZATION_CODE
152: --*************************************************************************
153: IS
154: --
155: CURSOR lcr_params(p_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
156: --*************************************************************************
157: --
158: -- CURSOR lcr_params
159: --

Line 185: FROM pay_payroll_actions PPA

181: ,fnd_date.canonical_to_date(pay_core_utils.get_parameter('TERMINATION_DATE_FROM', legislative_parameters))
182: ,fnd_date.canonical_to_date(pay_core_utils.get_parameter('TERMINATION_DATE_TO',legislative_parameters))
183: ,fnd_number.canonical_to_number(pay_core_utils.get_parameter('ASSIGNMENT_SET_ID',legislative_parameters))
184: ,pay_core_utils.get_parameter('REARCHIVE_FLAG',legislative_parameters)
185: FROM pay_payroll_actions PPA
186: WHERE PPA.payroll_action_id = p_payroll_action_id;
187: -- Local Variables
188: lc_procedure VARCHAR2(200);
189: i NUMBER := 0;

Line 190: lc_legislative_parameters pay_payroll_actions.legislative_parameters%type;

186: WHERE PPA.payroll_action_id = p_payroll_action_id;
187: -- Local Variables
188: lc_procedure VARCHAR2(200);
189: i NUMBER := 0;
190: lc_legislative_parameters pay_payroll_actions.legislative_parameters%type;
191: --
192: BEGIN
193: --
194: gb_debug :=hr_utility.debug_enabled ;

Line 250: PROCEDURE initialization_code ( p_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE )

246: hr_utility.set_location('Error in '||lc_procedure,999999);
247: RAISE;
248: END initialize;
249: --
250: PROCEDURE initialization_code ( p_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE )
251: --***************************************************************************
252: -- PROCEDURE
253: -- INITIALIZATION_CODE
254: --

Line 469: ,pay_payroll_actions PPA

465: ,PAI.action_information_id
466: ,PAC.assignment_action_id
467: FROM pay_action_information PAI
468: ,pay_assignment_actions PAC
469: ,pay_payroll_actions PPA
470: WHERE PAI.action_context_id = PAC.assignment_action_id
471: AND PAC.assignment_id = p_assignment_id
472: AND PAC.payroll_action_id = PPA.payroll_action_id
473: AND PAI.action_context_type = 'AAP'

Line 574: PROCEDURE assignment_action_code( p_payroll_action_id IN pay_payroll_actions.payroll_action_id%type

570: RETURN lb_return;
571: END range_person_on;
572: --
573: --
574: PROCEDURE assignment_action_code( p_payroll_action_id IN pay_payroll_actions.payroll_action_id%type
575: ,p_start_person IN per_all_people_f.person_id%type
576: ,p_end_person IN per_all_people_f.person_id%type
577: ,p_chunk IN NUMBER
578: )

Line 614: CURSOR lcu_emp_assignment_det_r(p_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE

610: -- PYUGEN process
611: --***********************************************************************/
612: IS
613: --
614: CURSOR lcu_emp_assignment_det_r(p_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE
615: ,p_business_group_id per_assignments_f.business_group_id%TYPE
616: ,p_effective_date DATE
617: ,p_payroll_id pay_payrolls_f.payroll_id%TYPE
618: ,p_with_hold_id hr_all_organization_units.organization_id%TYPE

Line 629: ,pay_payroll_actions PPA

625: FROM per_assignments_f PAF
626: ,per_people_f PPF
627: ,per_periods_of_service PPS
628: ,pay_population_ranges PPR
629: ,pay_payroll_actions PPA
630: WHERE PAF.person_id = PPF.person_id
631: AND PPF.person_id = PPS.person_id
632: AND PPA.payroll_action_id = p_payroll_action_id
633: AND PPA.payroll_action_id = PPR.payroll_action_id

Line 648: pay_payroll_actions PPA

644: AND TRUNC(NVL(PPS.actual_termination_date,p_effective_date)) BETWEEN PAF.effective_start_date AND PAF.effective_end_date
645: AND EXISTS(SELECT 1
646: FROM pay_jp_pre_tax PPT,
647: pay_assignment_actions PAA,
648: pay_payroll_actions PPA
649: WHERE PPA.effective_date BETWEEN gd_ystart_date AND gd_yend_date
650: AND PAA.assignment_id = PAF.assignment_id
651: AND PPA.business_group_id + 0 = p_business_group_id
652: AND PPA.action_type in ('R', 'Q', 'B', 'I')

Line 661: FROM pay_payroll_actions PPAV,

657: AND PPT.salary_category = 'TERM'
658: AND NVL(PPT.itax_organization_id,-999) = NVL(NVL(p_with_hold_id,PPT.itax_organization_id),-999)
659: AND NOT EXISTS(
660: SELECT null
661: FROM pay_payroll_actions PPAV,
662: pay_assignment_actions PAAV,
663: pay_action_interlocks PAI
664: WHERE PAI.locked_action_id = PAA.assignment_action_id
665: AND PAAV.assignment_action_id = PAI.locking_action_id

Line 670: CURSOR lcu_emp_assignment_det ( p_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE

666: AND PPAV.payroll_action_id = PAAV.payroll_action_id
667: AND PPAV.action_type = 'V'))
668: ORDER BY PAF.assignment_id;
669: --
670: CURSOR lcu_emp_assignment_det ( p_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE
671: ,p_start_person_id per_all_people_f.person_id%TYPE
672: ,p_end_person_id per_all_people_f.person_id%TYPE
673: ,p_business_group_id per_assignments_f.business_group_id%TYPE
674: ,p_effective_date DATE

Line 701: pay_payroll_actions PPA

697: AND TRUNC(NVL(PPS.actual_termination_date,p_effective_date)) BETWEEN PAF.effective_start_date AND PAF.effective_end_date
698: AND EXISTS(SELECT 1
699: FROM pay_jp_pre_tax PPT,
700: pay_assignment_actions PAA,
701: pay_payroll_actions PPA
702: WHERE PPA.effective_date BETWEEN gd_ystart_date AND gd_yend_date
703: AND PAA.assignment_id = PAF.assignment_id
704: AND PPA.business_group_id + 0 = p_business_group_id
705: AND PPA.action_type in ('R', 'Q', 'B', 'I')

Line 714: FROM pay_payroll_actions PPAV,

710: AND PPT.salary_category = 'TERM'
711: AND NVL(PPT.itax_organization_id,-999) = NVL(NVL(p_with_hold_id,PPT.itax_organization_id),-999)
712: AND NOT EXISTS(
713: SELECT null
714: FROM pay_payroll_actions PPAV,
715: pay_assignment_actions PAAV,
716: pay_action_interlocks PAI
717: WHERE PAI.locked_action_id = PAA.assignment_action_id
718: AND PAAV.assignment_action_id = PAI.locking_action_id

Line 911: , p_effective_date IN pay_payroll_actions.effective_date%type

907: RAISE;
908: END assignment_action_code;
909: --
910: PROCEDURE archive_code ( p_assignment_action_id IN pay_assignment_actions.assignment_action_id%type
911: , p_effective_date IN pay_payroll_actions.effective_date%type
912: )
913: --************************************************************************
914: -- PROCEDURE
915: -- ARCHIVE_CODE

Line 982: pay_payroll_actions PPA

978: AND PPS.period_of_service_id = NVL(PAF.period_of_service_id,PPS.period_of_service_id) -- #Bug 9569078
979: AND EXISTS(SELECT 1
980: FROM pay_jp_pre_tax PPT,
981: pay_assignment_actions PAA,
982: pay_payroll_actions PPA
983: WHERE PPA.effective_date BETWEEN gd_ystart_date AND gd_yend_date
984: AND PAA.assignment_id = PAF.assignment_id
985: AND PPA.action_type in ('R', 'Q', 'B', 'I')
986: AND PAA.payroll_action_id = PPA.payroll_action_id

Line 995: FROM pay_payroll_actions PPAV,

991: AND TRUNC(NVL(PPS.actual_termination_date,PPA.effective_date)) BETWEEN PPF.effective_start_date AND PPF.effective_end_date
992: AND TRUNC(NVL(PPS.actual_termination_date,PPA.effective_date)) BETWEEN PAF.effective_start_date AND PAF.effective_end_date
993: AND NOT EXISTS(
994: SELECT null
995: FROM pay_payroll_actions PPAV,
996: pay_assignment_actions PAAV,
997: pay_action_interlocks PAI
998: WHERE PAI.locked_action_id = PAA.assignment_action_id
999: AND PAAV.assignment_action_id = PAI.locking_action_id

Line 1040: pay_payroll_actions PPA

1036: ,NVL(sum(ppt.sp_ltax_shi), 0) muncipal_tax -- Bug 9525922
1037: ,NVL(sum(ppt.sp_ltax_to), 0) prefectural_tax -- Bug 9525922
1038: FROM pay_jp_pre_tax PPT,
1039: pay_assignment_actions PAA,
1040: pay_payroll_actions PPA
1041: WHERE PPA.effective_date BETWEEN gd_ystart_date AND gd_yend_date
1042: AND PPA.business_group_id + 0 = p_business_group_id
1043: AND PAA.assignment_id = p_assignment_id
1044: AND PPA.action_type in ('R', 'Q', 'B', 'I')

Line 1052: FROM pay_payroll_actions PPAV,

1048: AND PPT.action_status = 'C'
1049: AND PPT.salary_category = 'TERM'
1050: AND NOT EXISTS(
1051: SELECT null
1052: FROM pay_payroll_actions PPAV,
1053: pay_assignment_actions PAAV,
1054: pay_action_interlocks PAI
1055: WHERE PAI.locked_action_id = PAA.assignment_action_id
1056: AND PAAV.assignment_action_id = PAI.locking_action_id

Line 1068: pay_payroll_actions PPA

1064: ,PPA.effective_date
1065: ,PPA.date_earned
1066: FROM pay_jp_pre_tax PPT,
1067: pay_assignment_actions PAA,
1068: pay_payroll_actions PPA
1069: WHERE PPA.effective_date BETWEEN gd_ystart_date AND gd_yend_date
1070: AND PPA.business_group_id + 0 = p_business_group_id
1071: AND PAA.assignment_id = p_assignment_id
1072: AND PPA.action_type in ('R', 'Q', 'B', 'I')

Line 1080: FROM pay_payroll_actions PPAV,

1076: AND PPT.action_status = 'C'
1077: AND PPT.salary_category = 'TERM'
1078: AND NOT EXISTS(
1079: SELECT null
1080: FROM pay_payroll_actions PPAV,
1081: pay_assignment_actions PAAV,
1082: pay_action_interlocks PAI
1083: WHERE PAI.locked_action_id = PAA.assignment_action_id
1084: AND PAAV.assignment_action_id = PAI.locking_action_id

Line 1122: ,pay_payroll_actions PPA

1118: IS
1119: SELECT 'Y'
1120: FROM pay_action_information PAI
1121: ,pay_assignment_actions PAC
1122: ,pay_payroll_actions PPA
1123: WHERE PAI.action_context_id = PAC.assignment_action_id
1124: AND PAC.assignment_id = p_assignment_id
1125: AND PAC.payroll_action_id = PPA.payroll_action_id
1126: AND PAI.action_context_type = 'AAP'

Line 1172: ld_term_payment_date pay_payroll_actions.effective_date%TYPE;

1168: ln_term_ded_amt_spc NUMBER;
1169: ln_amt NUMBER;
1170: ln_term_ass_act_id pay_assignment_actions.assignment_action_id%TYPE;
1171: --
1172: ld_term_payment_date pay_payroll_actions.effective_date%TYPE;
1173: ld_date_earned pay_payroll_actions.date_earned%TYPE;
1174: ld_start_date DATE;
1175: l_yos NUMBER := null;
1176: l_ovr_yos NUMBER := null;

Line 1173: ld_date_earned pay_payroll_actions.date_earned%TYPE;

1169: ln_amt NUMBER;
1170: ln_term_ass_act_id pay_assignment_actions.assignment_action_id%TYPE;
1171: --
1172: ld_term_payment_date pay_payroll_actions.effective_date%TYPE;
1173: ld_date_earned pay_payroll_actions.date_earned%TYPE;
1174: ld_start_date DATE;
1175: l_yos NUMBER := null;
1176: l_ovr_yos NUMBER := null;
1177: l_st_date DATE := null;

Line 1510: ,pay_payroll_actions PPA

1506: --
1507: CURSOR lcu_assacts IS
1508: SELECT PAA.assignment_action_id
1509: FROM pay_assignment_actions PAA
1510: ,pay_payroll_actions PPA
1511: WHERE PAA.payroll_action_id = PPA.payroll_action_id
1512: AND PAA.action_status = 'C'
1513: AND PPA.report_type = gc_report_type
1514: AND NOT EXISTS( SELECT NULL