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

Line 181: SELECT pay_payroll_actions_s.nextval

177: lv_report_category :=p_format;
178: lv_year:=to_char(ld_Quater_start_date,'YYYY');
179: lv_reporting_quarter:=to_char(ld_Quater_end_date,'MMYYYY');
180:
181: SELECT pay_payroll_actions_s.nextval
182: INTO ln_locking_action_id
183: FROM dual;
184:
185: /*g_payroll_action_id:=ln_locking_action_id;*/

Line 197: INTO pay_payroll_actions

193: hr_utility.trace('p_report_option: '||p_report_option);
194:
195: hr_utility.trace('inserting payroll action: '||ln_locking_action_id);
196: INSERT
197: INTO pay_payroll_actions
198: (payroll_action_id
199: ,action_type
200: ,business_group_id
201: ,consolidation_set_id

Line 245: SELECT count(1) into l_previous_sqwl_run_check from pay_payroll_actions

241:
242: IF p_report_option <> 'SQWL_OLD' THEN --change with lookup code
243: FOR c_get_all_gres_rec IN c_get_all_gres LOOP
244:
245: SELECT count(1) into l_previous_sqwl_run_check from pay_payroll_actions
246: WHERE report_type = 'SQWL'
247: AND report_qualifier = p_state
248: AND business_group_id = p_business_group_id
249: AND effective_date = fnd_date.canonical_to_date (p_effective_date)

Line 257: pay_payroll_actions pact,

253:
254: select count(paa.assignment_action_id)
255: into l_chk_gre_assign_actions
256: from pay_assignment_actions paa,
257: pay_payroll_actions pact,
258: pay_payrolls_f ppf,
259: pay_us_emp_fed_tax_rules_f peft
260: where pact.effective_date
261: between ld_Quater_start_date

Line 413: FROM pay_payroll_actions pact

409: ) IS
410:
411: CURSOR c_get_child_payroll_actions IS
412: SELECT pact.payroll_action_id
413: FROM pay_payroll_actions pact
414: WHERE action_type = 'X'
415: AND report_type in ('SQWL', 'SMWL') /* Modified for Bug 14456648 */
416: AND pay_us_payroll_utils.get_parameter ('TRANSFER_PARENT_PAYROLL_ACTION'
417: ,pact.legislative_parameters) = p_payroll_action_id;

Line 421: FROM pay_payroll_actions

417: ,pact.legislative_parameters) = p_payroll_action_id;
418:
419: CURSOR c_get_report_type IS
420: SELECT report_type
421: FROM pay_payroll_actions
422: WHERE payroll_action_id = p_payroll_action_id;
423:
424: CURSOR c_get_child_count(cp_payroll_action_id NUMBER) IS
425: SELECT count (payroll_action_id)

Line 426: FROM pay_payroll_actions p1

422: WHERE payroll_action_id = p_payroll_action_id;
423:
424: CURSOR c_get_child_count(cp_payroll_action_id NUMBER) IS
425: SELECT count (payroll_action_id)
426: FROM pay_payroll_actions p1
427: WHERE pay_us_payroll_utils.get_parameter ('TRANSFER_PARENT_PAYROLL_ACTION'
428: ,p1.legislative_parameters) IN
429: (
430: SELECT pay_us_payroll_utils.get_parameter ('TRANSFER_PARENT_PAYROLL_ACTION'

Line 432: FROM pay_payroll_actions

428: ,p1.legislative_parameters) IN
429: (
430: SELECT pay_us_payroll_utils.get_parameter ('TRANSFER_PARENT_PAYROLL_ACTION'
431: ,legislative_parameters)
432: FROM pay_payroll_actions
433: WHERE payroll_action_id = cp_payroll_action_id
434: );
435:
436:

Line 439: l_report_type pay_payroll_actions.report_type%TYPE;

435:
436:
437: ln_child_payroll_action_id NUMBER;
438: l_req_id NUMBER;
439: l_report_type pay_payroll_actions.report_type%TYPE;
440: l_child_count NUMBER;
441: l_parent_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
442: BEGIN
443: /* hr_utility.trace_on(null,'SQWL'); */

Line 441: l_parent_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;

437: ln_child_payroll_action_id NUMBER;
438: l_req_id NUMBER;
439: l_report_type pay_payroll_actions.report_type%TYPE;
440: l_child_count NUMBER;
441: l_parent_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
442: BEGIN
443: /* hr_utility.trace_on(null,'SQWL'); */
444: hr_utility.trace('p_process_year : '||p_process_year);
445: hr_utility.trace('p_payroll_action_id : '||p_payroll_action_id);

Line 449: FROM pay_payroll_actions

445: hr_utility.trace('p_payroll_action_id : '||p_payroll_action_id);
446: hr_utility.trace('p_payroll_action_id_hidden : '||p_payroll_action_id_hidden);
447:
448: SELECT report_type INTO l_report_type
449: FROM pay_payroll_actions
450: WHERE payroll_action_id = p_payroll_action_id;
451:
452: IF l_report_type in ('SQWL_PARENT', 'SMWL_PARENT') THEN /* Modified for Bug 14456648 */
453: OPEN c_get_child_payroll_actions;

Line 514: INTO l_parent_payroll_action_id from pay_payroll_actions

510: hr_utility.trace('l_report_type '||l_report_type);
511:
512: BEGIN
513: SELECT pay_us_payroll_utils.get_parameter('TRANSFER_PARENT_PAYROLL_ACTION',legislative_parameters)
514: INTO l_parent_payroll_action_id from pay_payroll_actions
515: WHERE payroll_action_id = p_payroll_action_id;
516: EXCEPTION
517: WHEN NO_DATA_FOUND then
518: null;

Line 527: FROM pay_payroll_actions p1

523: hr_utility.trace('l_parent_payroll_action_id '||l_parent_payroll_action_id);
524: IF l_parent_payroll_action_id is not null then
525: BEGIN
526: SELECT count(payroll_action_id) into l_child_count
527: FROM pay_payroll_actions p1
528: WHERE pay_us_payroll_utils.get_parameter('TRANSFER_PARENT_PAYROLL_ACTION',p1.legislative_parameters)
529: = l_parent_payroll_action_id;
530: EXCEPTION
531: WHEN OTHERS THEN

Line 724: SELECT pay_payroll_actions_s.nextval

720: lv_report_category :=p_format;
721: lv_year:=to_char(ld_Month_start_date,'YYYY');
722: lv_reporting_month:=to_char(ld_Month_end_date,'MMYYYY');
723:
724: SELECT pay_payroll_actions_s.nextval
725: INTO ln_locking_action_id
726: FROM dual;
727:
728: /*g_payroll_action_id:=ln_locking_action_id;*/

Line 740: INTO pay_payroll_actions

736: hr_utility.trace('p_report_option: '||p_report_option);
737:
738: hr_utility.trace('inserting payroll action: '||ln_locking_action_id);
739: INSERT
740: INTO pay_payroll_actions
741: (payroll_action_id
742: ,action_type
743: ,business_group_id
744: ,consolidation_set_id

Line 788: SELECT count(1) into l_previous_smwl_run_check from pay_payroll_actions

784:
785: IF p_report_option <> 'SQWL_OLD' THEN --change with lookup code
786: FOR c_get_all_gres_rec IN c_get_all_gres LOOP
787:
788: SELECT count(1) into l_previous_smwl_run_check from pay_payroll_actions
789: WHERE report_type = 'SMWL'
790: AND report_qualifier = p_state
791: AND business_group_id = p_business_group_id
792: AND effective_date = fnd_date.canonical_to_date (p_effective_date)

Line 800: pay_payroll_actions pact,

796:
797: select count(paa.assignment_action_id)
798: into l_chk_gre_assign_actions
799: from pay_assignment_actions paa,
800: pay_payroll_actions pact,
801: pay_payrolls_f ppf,
802: pay_us_emp_fed_tax_rules_f peft
803: where pact.effective_date
804: between ld_Month_start_date