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

Line 90: in pay_payroll_actions table

86: correct minimum wage based on
87: the effective_date.
88: vpandya 31-Oct-2005 115.19 4710619 Changed range_cursor procedure.
89: Stamping 31-Dec-4712 in eff date
90: in pay_payroll_actions table
91: to view terminated and
92: rehired employees transactions.
93: sdahiya 28-Dec-2005 115.20 Support for salary change
94: transaction caused due to

Line 501: FROM pay_payroll_actions ppa

497: WHERE organization_id = cp_organization_id;
498:
499: CURSOR c_get_start_date(cp_tax_unit_id IN NUMBER) IS
500: SELECT pay_mx_utility.get_legi_param_val('END_DATE',LEGISLATIVE_PARAMETERS)
501: FROM pay_payroll_actions ppa
502: WHERE ppa.report_type = 'SS_ARCHIVE'
503: AND ppa.report_qualifier = 'SS_ARCHIVE'
504: AND ppa.report_category = 'RT'
505: AND pay_mx_utility.get_legi_param_val('GRE',LEGISLATIVE_PARAMETERS) =

Line 686: FROM pay_payroll_actions

682: ,pay_mx_utility.get_legi_param_val('MODE',
683: LEGISLATIVE_PARAMETERS) REPORT_MODE
684: ,pay_mx_utility.get_legi_param_val('PERIOD_ENDING_DATE',
685: LEGISLATIVE_PARAMETERS) PERIOD_ENDING_DATE
686: FROM pay_payroll_actions
687: WHERE payroll_action_id = cp_payroll_action_id;
688:
689: lv_end_date VARCHAR2(50);
690: lv_start_date VARCHAR2(50);

Line 4241: ,pay_payroll_actions ppa2

4237: from pay_element_entries_f pee
4238: ,pay_sub_classification_rules_f psc
4239: ,pay_element_classifications pec
4240: ,pay_assignment_actions paa
4241: ,pay_payroll_actions ppa2
4242: WHERE pee.assignment_id = p_assignment_id
4243: AND pee.effective_start_date <= p_periodic_end_date
4244: AND pee.effective_end_date >= p_periodic_start_date
4245: AND psc.business_group_id = p_business_group_id

Line 4264: FROM pay_payroll_actions ppa_prev

4260:
4261:
4262: CURSOR chk_prev_action IS
4263: SELECT 'Y'
4264: FROM pay_payroll_actions ppa_prev
4265: ,pay_assignment_actions paa_prev
4266: WHERE ppa_prev.report_type = 'SS_ARCHIVE'
4267: AND ppa_prev.report_qualifier = 'SS_ARCHIVE'
4268: AND ppa_prev.report_category = 'RT'

Line 4425: FROM pay_payroll_actions

4421: ln_pactid := p_payroll_action_id;
4422:
4423: SELECT COUNT(*)
4424: INTO gn_implementation
4425: FROM pay_payroll_actions
4426: WHERE report_type = 'SS_ARCHIVE'
4427: AND report_qualifier = 'SS_ARCHIVE'
4428: AND report_category = 'RT'
4429: AND pay_mx_utility.get_legi_param_val('GRE', legislative_parameters )

Line 4448: pay_payroll_actions ppa

4444:
4445: p_sqlstr :=
4446: 'SELECT DISTINCT paf.person_id
4447: FROM per_assignments_f paf,
4448: pay_payroll_actions ppa
4449: WHERE ppa.payroll_action_id = :p_payroll_action_id
4450: AND paf.business_group_id = ppa.business_group_id
4451: AND per_mx_ssaffl_archive.derive_gre_from_loc_scl(
4452: paf.location_id

Line 4467: ,pay_payroll_actions ppa

4463: p_sqlstr :=
4464: 'SELECT DISTINCT person_id FROM ( '||
4465: 'SELECT paf.person_id
4466: FROM per_assignments_f paf
4467: ,pay_payroll_actions ppa
4468: WHERE ppa.payroll_action_id = :p_payroll_action_id
4469: AND paf.business_group_id = ppa.business_group_id
4470: AND per_mx_ssaffl_archive.derive_gre_from_loc_scl(
4471: paf.location_id

Line 4483: update pay_payroll_actions

4479: hr_utility.set_location(gv_package || lv_procedure_name, 20);
4480:
4481: hr_utility_trace('--> Query formed p_sqlstr : ' || p_sqlstr );
4482:
4483: update pay_payroll_actions
4484: set effective_date = fnd_date.canonical_to_date('4712/12/31')
4485: where payroll_action_id = p_payroll_action_id;
4486:
4487: /*Begin - Bug 13357684*/

Line 4524: FROM pay_payroll_actions ppa

4520: SELECT paf.person_id
4521: ,decode(paf.primary_flag, 'Y', 'Y', 'Z')
4522: ,paf.assignment_id
4523: ,'N' variable_idw
4524: FROM pay_payroll_actions ppa
4525: ,per_assignments_f paf
4526: WHERE ppa.payroll_action_id = cp_payroll_action_id
4527: AND ppa.business_group_id = cp_business_group_id
4528: AND paf.business_group_id = ppa.business_group_id

Line 4542: ,pay_payroll_actions ppa

4538: ,decode(paf.primary_flag, 'Y', 'Y', 'Z')
4539: ,paf.assignment_id
4540: ,'Y' variable_idw
4541: FROM per_assignments_f paf
4542: ,pay_payroll_actions ppa
4543: ,pay_element_entries_f pee
4544: ,pay_sub_classification_rules_f psc
4545: ,pay_element_classifications pec
4546: ,pay_assignment_actions paa

Line 4547: ,pay_payroll_actions ppa2

4543: ,pay_element_entries_f pee
4544: ,pay_sub_classification_rules_f psc
4545: ,pay_element_classifications pec
4546: ,pay_assignment_actions paa
4547: ,pay_payroll_actions ppa2
4548: WHERE ppa.payroll_action_id = cp_payroll_action_id
4549: AND paf.business_group_id = ppa.business_group_id
4550: AND paf.person_id BETWEEN cp_start_person_id
4551: AND cp_end_person_id

Line 4577: FROM pay_payroll_actions ppa_prev

4573: WHERE prr.assignment_action_id = paa.assignment_action_id
4574: AND prr.element_type_id = pee.element_type_id )
4575: AND NOT EXISTS (
4576: SELECT 1
4577: FROM pay_payroll_actions ppa_prev
4578: ,pay_assignment_actions paa_prev
4579: WHERE ppa_prev.report_type = 'SS_ARCHIVE'
4580: AND ppa_prev.report_qualifier = 'SS_ARCHIVE'
4581: AND ppa_prev.report_category = 'RT'

Line 4608: FROM pay_payroll_actions ppa

4604: SELECT paf.person_id
4605: ,decode(paf.primary_flag, 'Y', 'Y', 'Z')
4606: ,paf.assignment_id
4607: ,'N' variable_idw
4608: FROM pay_payroll_actions ppa
4609: ,per_assignments_f paf
4610: ,pay_population_ranges ppr
4611: WHERE ppa.payroll_action_id = cp_payroll_action_id
4612: AND ppr.payroll_action_id = ppa.payroll_action_id

Line 4625: FROM pay_payroll_actions ppa

4621: SELECT paf.person_id
4622: ,decode(paf.primary_flag, 'Y', 'Y', 'Z')
4623: ,paf.assignment_id
4624: ,'Y' variable_idw
4625: FROM pay_payroll_actions ppa
4626: ,per_assignments_f paf
4627: ,pay_population_ranges ppr
4628: ,pay_element_entries_f pee
4629: ,pay_sub_classification_rules_f psc

Line 4632: ,pay_payroll_actions ppa2

4628: ,pay_element_entries_f pee
4629: ,pay_sub_classification_rules_f psc
4630: ,pay_element_classifications pec
4631: ,pay_assignment_actions paa
4632: ,pay_payroll_actions ppa2
4633: WHERE ppa.payroll_action_id = cp_payroll_action_id
4634: AND ppr.payroll_action_id = ppa.payroll_action_id
4635: AND ppr.chunk_number = cp_chunk_number
4636: AND paf.person_id = ppr.person_id

Line 4662: FROM pay_payroll_actions ppa_prev

4658: WHERE prr.assignment_action_id = paa.assignment_action_id
4659: AND prr.element_type_id = pee.element_type_id )
4660: AND NOT EXISTS (
4661: SELECT 1
4662: FROM pay_payroll_actions ppa_prev
4663: ,pay_assignment_actions paa_prev
4664: WHERE ppa_prev.report_type = 'SS_ARCHIVE'
4665: AND ppa_prev.report_qualifier = 'SS_ARCHIVE'
4666: AND ppa_prev.report_category = 'RT'

Line 4693: FROM pay_payroll_actions ppa

4689: SELECT paf.person_id
4690: ,decode(paf.primary_flag, 'Y', 'Y', 'Z')
4691: ,paf.assignment_id
4692: ,'N' variable_idw
4693: FROM pay_payroll_actions ppa
4694: ,per_assignments_f paf
4695: WHERE ppa.payroll_action_id = cp_payroll_action_id
4696: AND ppa.business_group_id = cp_business_group_id
4697: AND paf.business_group_id = ppa.business_group_id

Line 4721: ,pay_payroll_actions ppa

4717: ,decode(paf.primary_flag, 'Y', 'Y', 'Z')
4718: ,paf.assignment_id
4719: ,'Y' variable_idw
4720: FROM per_assignments_f paf
4721: ,pay_payroll_actions ppa
4722: WHERE ppa.payroll_action_id = cp_payroll_action_id
4723: AND ppa.business_group_id = cp_business_group_id
4724: AND paf.business_group_id = ppa.business_group_id
4725: AND paf.person_id BETWEEN cp_start_person_id

Line 4759: FROM pay_payroll_actions ppa

4755: SELECT paf.person_id
4756: ,decode(paf.primary_flag, 'Y', 'Y', 'Z')
4757: ,paf.assignment_id
4758: ,'N' variable_idw
4759: FROM pay_payroll_actions ppa
4760: ,per_assignments_f paf
4761: ,pay_population_ranges ppr
4762: WHERE ppa.payroll_action_id = cp_payroll_action_id
4763: AND ppr.payroll_action_id = ppa.payroll_action_id

Line 4787: FROM pay_payroll_actions ppa

4783: SELECT paf.person_id
4784: ,decode(paf.primary_flag, 'Y', 'Y', 'Z')
4785: ,paf.assignment_id
4786: ,'Y' variable_idw
4787: FROM pay_payroll_actions ppa
4788: ,per_assignments_f paf
4789: ,pay_population_ranges ppr
4790: WHERE ppa.payroll_action_id = cp_payroll_action_id
4791: AND ppr.payroll_action_id = ppa.payroll_action_id

Line 5437: FROM pay_payroll_actions

5433: fnd_date.canonical_to_date(
5434: pay_mx_utility.get_legi_param_val(
5435: 'END_DATE',
5436: LEGISLATIVE_PARAMETERS)) END_DATE
5437: FROM pay_payroll_actions
5438: WHERE payroll_action_id = cp_payroll_action_id;
5439:
5440: ln_gre_id NUMBER;
5441: ld_start_date DATE;

Line 5461: FROM pay_payroll_actions

5457: CLOSE c_payroll_action_info;
5458:
5459: SELECT COUNT(*)
5460: INTO gn_implementation
5461: FROM pay_payroll_actions
5462: WHERE report_type = 'SS_ARCHIVE'
5463: AND report_qualifier = 'SS_ARCHIVE'
5464: AND report_category = 'RT'
5465: AND pay_mx_utility.get_legi_param_val('GRE', legislative_parameters )

Line 5556: FROM pay_payroll_actions ppa

5552: AND pus.status = 'C';
5553:
5554: CURSOR csr_arch_exists IS
5555: SELECT 'Y'
5556: FROM pay_payroll_actions ppa
5557: WHERE ppa.report_type = 'SS_ARCHIVE'
5558: AND ppa.report_qualifier = 'SS_ARCHIVE'
5559: AND ppa.report_category = 'RT'
5560: AND ppa.business_group_id = p_business_group_id;