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

Line 57: leg_param pay_payroll_actions.legislative_parameters%TYPE;

53: --------------------------- range_cursor ---------------------------------
54: PROCEDURE range_cursor (pactid IN NUMBER
55: ,sqlstr OUT NOCOPY VARCHAR2) IS
56:
57: leg_param pay_payroll_actions.legislative_parameters%TYPE;
58: l_consolidation_set_id NUMBER;
59: l_payroll_id NUMBER;
60: l_organization_id NUMBER;
61: l_location_id NUMBER;

Line 76: FROM pay_payroll_actions ppa

72: hr_utility.set_location(l_proc_name,5);
73:
74: SELECT legislative_parameters
75: INTO leg_param
76: FROM pay_payroll_actions ppa
77: WHERE ppa.payroll_action_id = pactid;
78:
79: hr_utility.set_location(l_proc_name,10);
80: SELECT ppa.legislative_parameters,

Line 94: FROM pay_payroll_actions ppa

90: l_organization_id,
91: l_leg_start_date,
92: l_leg_end_date,
93: l_business_group_id
94: FROM pay_payroll_actions ppa
95: WHERE ppa.payroll_action_id = pactid;
96:
97: hr_utility.set_location(l_proc_name,15);
98: IF l_consolidation_set_id IS NOT NULL THEN

Line 117: FROM pay_payroll_actions ppa,

113:
114: hr_utility.set_location(l_proc_name,40);
115: sqlstr :=
116: 'SELECT distinct asg.person_id
117: FROM pay_payroll_actions ppa,
118: pay_payroll_actions pa1,
119: pay_assignment_actions act,
120: per_assignments_f asg,
121: pay_payrolls_f ppf

Line 118: pay_payroll_actions pa1,

114: hr_utility.set_location(l_proc_name,40);
115: sqlstr :=
116: 'SELECT distinct asg.person_id
117: FROM pay_payroll_actions ppa,
118: pay_payroll_actions pa1,
119: pay_assignment_actions act,
120: per_assignments_f asg,
121: pay_payrolls_f ppf
122: WHERE ppa.payroll_action_id = :payroll_action_id

Line 168: FROM pay_payroll_actions ppa

164: ,pay_payrg_pkg.get_parameter('PASID',ppa.legislative_parameters) assignment_set_id
165: ,pay_payrg_pkg.get_parameter('L_E_ID',ppa.legislative_parameters) legal_employer_id
166: ,ppa.start_date start_date
167: ,ppa.effective_date effective_date
168: FROM pay_payroll_actions ppa
169: WHERE ppa.payroll_action_id = pactid;
170:
171: CURSOR c_actions(
172: c_stperson number

Line 194: pay_payroll_actions ppa, /* pre-payments and reversals

190: ppa.effective_date,
191: act.source_action_id,
192: nvl(ppa.start_date,ppa.effective_date)
193: FROM pay_payrolls_f ppf,
194: pay_payroll_actions ppa, /* pre-payments and reversals
195: payroll action id */
196: pay_assignment_actions act,
197: per_assignments_f paf
198: WHERE (c_payroll_id is NULL

Line 253: pay_payroll_actions ppa ,

249: nvl(ppa.start_date,ppa.effective_date)
250: FROM hr_assignment_set_amendments hasa ,
251: per_assignments_f paf ,
252: pay_assignment_actions act ,
253: pay_payroll_actions ppa ,
254: pay_payrolls_f ppf
255: WHERE (c_payroll_id IS NULL
256: OR ppa.payroll_id = c_payroll_id)
257: AND ppa.consolidation_set_id +0 = nvl(c_consolidation_set_id,

Line 311: pay_payroll_actions ppa

307: SELECT ppa.effective_date,
308: ppa.action_type
309: FROM pay_action_interlocks pai,
310: pay_assignment_actions paa,
311: pay_payroll_actions ppa
312: WHERE pai.locking_action_id = cp_pre_pymt_action_id
313: AND paa.assignment_action_id = pai.locked_action_id
314: AND ppa.payroll_action_id = paa.payroll_action_id
315: AND ppa.action_type in ('R', 'Q', 'B');

Line 321: pay_payroll_actions ppa

317: CURSOR c_payroll_run (cp_pre_pymt_action_id IN NUMBER) IS
318: SELECT assignment_action_id, ppa.action_type
319: FROM pay_action_interlocks pai,
320: pay_assignment_actions paa,
321: pay_payroll_actions ppa
322: WHERE pai.locking_action_id = cp_pre_pymt_action_id
323: AND paa.assignment_action_id = pai.locked_action_id
324: AND ppa.payroll_action_id = paa.payroll_action_id
325: AND ((paa.run_type_id IS NULL and paa.source_action_id IS NULL) OR

Line 342: pay_payroll_actions ppa

338: CURSOR c_multi_ba_acts(cp_pre_pymt_action_id IN NUMBER) IS
339: SELECT assignment_action_id, ppa.action_type
340: FROM pay_action_interlocks pai,
341: pay_assignment_actions paa,
342: pay_payroll_actions ppa
343: WHERE pai.locking_action_id = cp_pre_pymt_action_id
344: AND paa.assignment_action_id = pai.locked_action_id
345: AND ppa.payroll_action_id = paa.payroll_action_id
346: AND ((paa.run_type_id IS NULL AND paa.source_action_id IS NULL) OR

Line 384: pay_payroll_actions ppa,

380: SELECT max(paa2.assignment_action_id)
381: FROM pay_assignment_actions paa2, -- assignment_actions for slave payroll runs.
382: pay_assignment_actions paa1, -- assignment_action for master payroll run
383: pay_run_Types_f prt,
384: pay_payroll_actions ppa,
385: pay_action_interlocks pai
386: WHERE pai.locking_action_id = cp_pre_pymt_action_id
387: AND pai.locked_action_id = paa1.assignment_action_id
388: AND paa1.source_action_id IS NULL -- master assignment_action

Line 412: pay_payroll_actions ppa,

408: -- assignment_actions for slave payroll runs.
409: pay_assignment_actions paa1,
410: -- assignment_action for master payroll run
411: pay_run_Types_f prt,
412: pay_payroll_actions ppa,
413: pay_action_interlocks pai
414: WHERE pai.locking_action_id = cp_pre_pymt_action_id
415: AND pai.locked_action_id = paa1.assignment_action_id
416: AND paa1.source_action_id is null -- master assignment_action

Line 431: pay_payroll_actions ppa

427: CURSOR c_check_for_void (cp_pre_pymt_action_id IN NUMBER) IS
428: SELECT 'Y'
429: FROM pay_action_interlocks pai,
430: pay_assignment_actions paa,
431: pay_payroll_actions ppa
432: WHERE pai.locking_action_id = cp_pre_pymt_action_id
433: AND paa.assignment_action_id = pai.locked_action_id
434: AND ppa.payroll_action_id = paa.payroll_action_id
435: AND action_type = 'V';

Line 451: l_leg_param pay_payroll_actions.legislative_parameters%TYPE;

447: num NUMBER;
448: runactid NUMBER;
449: actiontype VARCHAR2(1);
450: serialno VARCHAR2(30);
451: l_leg_param pay_payroll_actions.legislative_parameters%TYPE;
452: l_asg_set_id NUMBER;
453: l_asg_flag VARCHAR2(10);
454: l_effective_date DATE;
455: l_start_date DATE;

Line 469: l_payroll_id pay_payroll_actions.payroll_id%TYPE;

465: lv_source_action_id NUMBER;
466: l_asg_act_id NUMBER;
467: l_action_insert VARCHAR2(1);
468: l_void_action VARCHAR2(1);
469: l_payroll_id pay_payroll_actions.payroll_id%TYPE;
470: l_location_id per_all_assignments_f.location_id%TYPE;
471: l_consolidation_set_id pay_payroll_actions.consolidation_set_id%TYPE;
472: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;
473: l_person_id per_all_assignments_f.person_id%TYPE;

Line 471: l_consolidation_set_id pay_payroll_actions.consolidation_set_id%TYPE;

467: l_action_insert VARCHAR2(1);
468: l_void_action VARCHAR2(1);
469: l_payroll_id pay_payroll_actions.payroll_id%TYPE;
470: l_location_id per_all_assignments_f.location_id%TYPE;
471: l_consolidation_set_id pay_payroll_actions.consolidation_set_id%TYPE;
472: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;
473: l_person_id per_all_assignments_f.person_id%TYPE;
474: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
475: l_organization_id per_all_assignments_f.organization_id%TYPE;

Line 477: cp_start_date pay_payroll_actions.effective_date%TYPE;

473: l_person_id per_all_assignments_f.person_id%TYPE;
474: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
475: l_organization_id per_all_assignments_f.organization_id%TYPE;
476: l_assignment_set_id hr_assignment_set_amendments.assignment_set_id%TYPE;
477: cp_start_date pay_payroll_actions.effective_date%TYPE;
478: cp_effective_date pay_payroll_actions.effective_date%TYPE;
479: l_run_eff_date DATE;
480: run_action_type VARCHAR2(30);
481: lv_max_run_flag VARCHAR2(1) := 'N' ;

Line 478: cp_effective_date pay_payroll_actions.effective_date%TYPE;

474: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
475: l_organization_id per_all_assignments_f.organization_id%TYPE;
476: l_assignment_set_id hr_assignment_set_amendments.assignment_set_id%TYPE;
477: cp_start_date pay_payroll_actions.effective_date%TYPE;
478: cp_effective_date pay_payroll_actions.effective_date%TYPE;
479: l_run_eff_date DATE;
480: run_action_type VARCHAR2(30);
481: lv_max_run_flag VARCHAR2(1) := 'N' ;
482: lv_max_run_id NUMBER;

Line 496: FROM pay_payroll_actions ppa

492: hr_utility.set_location('Entering '||l_proc_name,5);
493:
494: SELECT legislative_parameters
495: INTO l_leg_param
496: FROM pay_payroll_actions ppa
497: WHERE ppa.payroll_action_id = pactid;
498:
499: hr_utility.set_location(l_proc_name,10);
500:

Line 874: FROM pay_payroll_actions ppa

870: SELECT pay_payrg_pkg.get_parameter('T_U_ID',ppa.legislative_parameters) tax_unit_id,
871: pay_payrg_pkg.get_parameter('O_ID',ppa.legislative_parameters) organization_id,
872: pay_payrg_pkg.get_parameter('B_G_ID',ppa.legislative_parameters) business_group_id,
873: pay_payrg_pkg.get_parameter('RP_DM',ppa.legislative_parameters) dimension_id
874: FROM pay_payroll_actions ppa
875: WHERE ppa.payroll_action_id = pactid;
876:
877: CURSOR c_get_balance_dimensions (dimtype varchar2)is
878: SELECT balance_dimension_id

Line 1003: FROM pay_payroll_actions ppa

999:
1000: CURSOR c_get_payroll_period (asg_action_id NUMBER) is
1001: SELECT ptp.start_date
1002: ,ptp.end_date
1003: FROM pay_payroll_actions ppa
1004: ,pay_assignment_actions paa
1005: ,per_time_periods ptp
1006: WHERE ppa.payroll_action_id = paa.payroll_action_id
1007: AND ptp.time_period_id = ppa.time_period_id

Line 1013: FROM pay_payroll_actions ppa

1009:
1010: CURSOR c_get_payroll_details (asg_action_id NUMBER) is
1011: SELECT ppf.payroll_name
1012: ,pcs.consolidation_set_name
1013: FROM pay_payroll_actions ppa
1014: ,pay_assignment_actions paa
1015: ,pay_payrolls_f ppf
1016: ,pay_consolidation_sets pcs
1017: WHERE ppa.payroll_action_id = paa.payroll_action_id

Line 1205: FROM pay_payroll_actions ppa

1201: pay_payrg_pkg.get_parameter('P_S1', ppa.legislative_parameters) sort1,
1202: pay_payrg_pkg.get_parameter('RP_DM',ppa.legislative_parameters) dimension_id,
1203: ppa.start_date start_date,
1204: ppa.effective_date effective_date
1205: FROM pay_payroll_actions ppa
1206: WHERE ppa.payroll_action_id = pactid;
1207:
1208: CURSOR c_get_payroll_name (cp_payroll_id NUMBER) IS
1209: SELECT payroll_name

Line 1275: ld_start_date pay_payroll_actions.effective_date%TYPE;

1271: ln_org_id NUMBER;
1272: ln_legal_emp_id NUMBER;
1273: ln_assignment_set_id NUMBER;
1274: lv_sort_1 VARCHAR2(30);
1275: ld_start_date pay_payroll_actions.effective_date%TYPE;
1276: ld_effective_date pay_payroll_actions.effective_date%TYPE;
1277: ln_dimension_id NUMBER;
1278: lv_payroll_name VARCHAR2(240);
1279: lv_consolidation_set_name VARCHAR2(240);

Line 1276: ld_effective_date pay_payroll_actions.effective_date%TYPE;

1272: ln_legal_emp_id NUMBER;
1273: ln_assignment_set_id NUMBER;
1274: lv_sort_1 VARCHAR2(30);
1275: ld_start_date pay_payroll_actions.effective_date%TYPE;
1276: ld_effective_date pay_payroll_actions.effective_date%TYPE;
1277: ln_dimension_id NUMBER;
1278: lv_payroll_name VARCHAR2(240);
1279: lv_consolidation_set_name VARCHAR2(240);
1280: lv_gre_name VARCHAR2(240);

Line 1417: FROM pay_payroll_actions pa1

1413: ln_payroll_action_id := pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');
1414:
1415: SELECT get_parameter('REMOVE_ACT', pa1.legislative_parameters)
1416: INTO l_remove_act
1417: FROM pay_payroll_actions pa1
1418: WHERE pa1.payroll_action_id = ln_payroll_action_id;
1419:
1420: hr_utility.set_location ( l_proc_name ,30);
1421: IF (l_remove_act IS NULL OR l_remove_act = 'Y') THEN

Line 1529: FROM pay_payroll_actions ppa

1525: FND_FILE.PUT_LINE(FND_FILE.LOG,'pay_mx_payreg_pkg.sort_action ');
1526: hr_utility.set_location ('Entering'||l_proc_name ,10);
1527: SELECT pay_payrg_pkg.get_parameter('P_S1', ppa.legislative_parameters)
1528: INTO l_sort_1
1529: FROM pay_payroll_actions ppa
1530: WHERE ppa.payroll_action_id = payactid;
1531: --Modified the sort query for sorting by employee name and payroll name
1532: hr_utility.set_location ('Entering'||l_proc_name ,20);
1533: sqlstr :=

Line 1536: pay_payroll_actions ppa

1532: hr_utility.set_location ('Entering'||l_proc_name ,20);
1533: sqlstr :=
1534: 'SELECT paa.rowid
1535: FROM pay_assignment_actions paa,
1536: pay_payroll_actions ppa
1537: WHERE ppa.payroll_action_id = :payactid
1538: and paa.payroll_action_id = ppa.payroll_action_id
1539: order by(pay_mx_payreg_pkg.sort_option (
1540: ''GRE'',

Line 1552: FROM pay_payroll_actions ppa2,

1548: paa.assignment_id,
1549: ppa.effective_date,
1550: paa.tax_unit_id))),
1551: (SELECT ppa2.effective_date
1552: FROM pay_payroll_actions ppa2,
1553: pay_assignment_actions paa2
1554: WHERE paa2.assignment_action_id = to_number(substr(paa.serial_number,2))
1555: and paa2.payroll_action_id = ppa2.payroll_action_id
1556: and ppa2.action_type in (''R'', ''Q'', ''V'', ''B'')

Line 1571: token_val pay_payroll_actions.legislative_parameters%type;

1567: RETURN VARCHAR2
1568: IS
1569: start_ptr NUMBER;
1570: end_ptr NUMBER;
1571: token_val pay_payroll_actions.legislative_parameters%type;
1572: par_value pay_payroll_actions.legislative_parameters%type;
1573: l_proc_name VARCHAR2(100) := g_package_name||'.GET_PARAMETER';
1574: BEGIN
1575:

Line 1572: par_value pay_payroll_actions.legislative_parameters%type;

1568: IS
1569: start_ptr NUMBER;
1570: end_ptr NUMBER;
1571: token_val pay_payroll_actions.legislative_parameters%type;
1572: par_value pay_payroll_actions.legislative_parameters%type;
1573: l_proc_name VARCHAR2(100) := g_package_name||'.GET_PARAMETER';
1574: BEGIN
1575:
1576: token_val := name || '=';