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 432: FROM pay_payroll_actions ppa

428: WHERE organization_id = cp_organization_id;
429:
430: CURSOR c_get_start_date(cp_tax_unit_id IN NUMBER) IS
431: SELECT pay_mx_utility.get_legi_param_val('END_DATE',LEGISLATIVE_PARAMETERS)
432: FROM pay_payroll_actions ppa
433: WHERE ppa.report_type = 'SS_ARCHIVE'
434: AND ppa.report_qualifier = 'SS_ARCHIVE'
435: AND ppa.report_category = 'RT'
436: AND pay_mx_utility.get_legi_param_val('GRE',LEGISLATIVE_PARAMETERS) =

Line 617: FROM pay_payroll_actions

613: ,pay_mx_utility.get_legi_param_val('MODE',
614: LEGISLATIVE_PARAMETERS) REPORT_MODE
615: ,pay_mx_utility.get_legi_param_val('PERIOD_ENDING_DATE',
616: LEGISLATIVE_PARAMETERS) PERIOD_ENDING_DATE
617: FROM pay_payroll_actions
618: WHERE payroll_action_id = cp_payroll_action_id;
619:
620: lv_end_date VARCHAR2(50);
621: lv_start_date VARCHAR2(50);

Line 4036: FROM pay_payroll_actions

4032: ln_pactid := p_payroll_action_id;
4033:
4034: SELECT COUNT(*)
4035: INTO gn_implementation
4036: FROM pay_payroll_actions
4037: WHERE report_type = 'SS_ARCHIVE'
4038: AND report_qualifier = 'SS_ARCHIVE'
4039: AND report_category = 'RT'
4040: AND pay_mx_utility.get_legi_param_val('GRE', legislative_parameters )

Line 4059: pay_payroll_actions ppa

4055:
4056: p_sqlstr :=
4057: 'SELECT DISTINCT paf.person_id
4058: FROM per_assignments_f paf,
4059: pay_payroll_actions ppa
4060: WHERE ppa.payroll_action_id = :p_payroll_action_id
4061: AND paf.business_group_id = ppa.business_group_id
4062: AND per_mx_ssaffl_archive.derive_gre_from_loc_scl(
4063: paf.location_id

Line 4077: ,pay_payroll_actions ppa

4073: p_sqlstr :=
4074: 'SELECT DISTINCT person_id FROM ( '||
4075: 'SELECT paf.person_id
4076: FROM per_assignments_f paf
4077: ,pay_payroll_actions ppa
4078: WHERE ppa.payroll_action_id = :p_payroll_action_id
4079: AND paf.business_group_id = ppa.business_group_id
4080: AND per_mx_ssaffl_archive.derive_gre_from_loc_scl(
4081: paf.location_id

Line 4103: ,pay_payroll_actions ppa

4099: p_sqlstr := p_sqlstr ||
4100: ') UNION ALL '||
4101: 'SELECT paf.person_id
4102: FROM per_assignments_f paf
4103: ,pay_payroll_actions ppa
4104: ,pay_element_entries_f pee
4105: ,pay_sub_classification_rules_f psc
4106: ,pay_element_classifications pec
4107: ,pay_assignment_actions paa

Line 4108: ,pay_payroll_actions ppa2

4104: ,pay_element_entries_f pee
4105: ,pay_sub_classification_rules_f psc
4106: ,pay_element_classifications pec
4107: ,pay_assignment_actions paa
4108: ,pay_payroll_actions ppa2
4109: WHERE ppa.payroll_action_id = '|| ln_pactid ||' '||
4110: 'AND paf.business_group_id = ppa.business_group_id
4111: AND per_mx_ssaffl_archive.derive_gre_from_loc_scl(
4112: paf.location_id

Line 4141: FROM pay_payroll_actions ppa_prev

4137: WHERE prr.assignment_action_id = paa.assignment_action_id
4138: AND prr.element_type_id = pee.element_type_id ) '||
4139: 'AND NOT EXISTS (
4140: SELECT 1
4141: FROM pay_payroll_actions ppa_prev
4142: ,pay_assignment_actions paa_prev
4143: WHERE ppa_prev.report_type = ''SS_ARCHIVE''
4144: AND ppa_prev.report_qualifier = ''SS_ARCHIVE''
4145: AND ppa_prev.report_category = ''RT''

Line 4167: update pay_payroll_actions

4163: hr_utility.set_location(gv_package || lv_procedure_name, 20);
4164:
4165: hr_utility_trace('--> Query formed p_sqlstr : ' || p_sqlstr );
4166:
4167: update pay_payroll_actions
4168: set effective_date = fnd_date.canonical_to_date('4712/12/31')
4169: where payroll_action_id = p_payroll_action_id;
4170:
4171: hr_utility.set_location(gv_package || lv_procedure_name, 30);

Line 4193: FROM pay_payroll_actions ppa

4189: SELECT paf.person_id
4190: ,decode(paf.primary_flag, 'Y', 'Y', 'Z')
4191: ,paf.assignment_id
4192: ,'N' variable_idw
4193: FROM pay_payroll_actions ppa
4194: ,per_assignments_f paf
4195: WHERE ppa.payroll_action_id = cp_payroll_action_id
4196: AND ppa.business_group_id = cp_business_group_id
4197: AND paf.business_group_id = ppa.business_group_id

Line 4211: ,pay_payroll_actions ppa

4207: ,decode(paf.primary_flag, 'Y', 'Y', 'Z')
4208: ,paf.assignment_id
4209: ,'Y' variable_idw
4210: FROM per_assignments_f paf
4211: ,pay_payroll_actions ppa
4212: ,pay_element_entries_f pee
4213: ,pay_sub_classification_rules_f psc
4214: ,pay_element_classifications pec
4215: ,pay_assignment_actions paa

Line 4216: ,pay_payroll_actions ppa2

4212: ,pay_element_entries_f pee
4213: ,pay_sub_classification_rules_f psc
4214: ,pay_element_classifications pec
4215: ,pay_assignment_actions paa
4216: ,pay_payroll_actions ppa2
4217: WHERE ppa.payroll_action_id = cp_payroll_action_id
4218: AND paf.business_group_id = ppa.business_group_id
4219: AND paf.person_id BETWEEN cp_start_person_id
4220: AND cp_end_person_id

Line 4246: FROM pay_payroll_actions ppa_prev

4242: WHERE prr.assignment_action_id = paa.assignment_action_id
4243: AND prr.element_type_id = pee.element_type_id )
4244: AND NOT EXISTS (
4245: SELECT 1
4246: FROM pay_payroll_actions ppa_prev
4247: ,pay_assignment_actions paa_prev
4248: WHERE ppa_prev.report_type = 'SS_ARCHIVE'
4249: AND ppa_prev.report_qualifier = 'SS_ARCHIVE'
4250: AND ppa_prev.report_category = 'RT'

Line 4277: FROM pay_payroll_actions ppa

4273: SELECT paf.person_id
4274: ,decode(paf.primary_flag, 'Y', 'Y', 'Z')
4275: ,paf.assignment_id
4276: ,'N' variable_idw
4277: FROM pay_payroll_actions ppa
4278: ,per_assignments_f paf
4279: ,pay_population_ranges ppr
4280: WHERE ppa.payroll_action_id = cp_payroll_action_id
4281: AND ppr.payroll_action_id = ppa.payroll_action_id

Line 4294: FROM pay_payroll_actions ppa

4290: SELECT paf.person_id
4291: ,decode(paf.primary_flag, 'Y', 'Y', 'Z')
4292: ,paf.assignment_id
4293: ,'Y' variable_idw
4294: FROM pay_payroll_actions ppa
4295: ,per_assignments_f paf
4296: ,pay_population_ranges ppr
4297: ,pay_element_entries_f pee
4298: ,pay_sub_classification_rules_f psc

Line 4301: ,pay_payroll_actions ppa2

4297: ,pay_element_entries_f pee
4298: ,pay_sub_classification_rules_f psc
4299: ,pay_element_classifications pec
4300: ,pay_assignment_actions paa
4301: ,pay_payroll_actions ppa2
4302: WHERE ppa.payroll_action_id = cp_payroll_action_id
4303: AND ppr.payroll_action_id = ppa.payroll_action_id
4304: AND ppr.chunk_number = cp_chunk_number
4305: AND paf.person_id = ppr.person_id

Line 4331: FROM pay_payroll_actions ppa_prev

4327: WHERE prr.assignment_action_id = paa.assignment_action_id
4328: AND prr.element_type_id = pee.element_type_id )
4329: AND NOT EXISTS (
4330: SELECT 1
4331: FROM pay_payroll_actions ppa_prev
4332: ,pay_assignment_actions paa_prev
4333: WHERE ppa_prev.report_type = 'SS_ARCHIVE'
4334: AND ppa_prev.report_qualifier = 'SS_ARCHIVE'
4335: AND ppa_prev.report_category = 'RT'

Line 4970: FROM pay_payroll_actions

4966: fnd_date.canonical_to_date(
4967: pay_mx_utility.get_legi_param_val(
4968: 'END_DATE',
4969: LEGISLATIVE_PARAMETERS)) END_DATE
4970: FROM pay_payroll_actions
4971: WHERE payroll_action_id = cp_payroll_action_id;
4972:
4973: ln_gre_id NUMBER;
4974: ld_start_date DATE;

Line 4994: FROM pay_payroll_actions

4990: CLOSE c_payroll_action_info;
4991:
4992: SELECT COUNT(*)
4993: INTO gn_implementation
4994: FROM pay_payroll_actions
4995: WHERE report_type = 'SS_ARCHIVE'
4996: AND report_qualifier = 'SS_ARCHIVE'
4997: AND report_category = 'RT'
4998: AND pay_mx_utility.get_legi_param_val('GRE', legislative_parameters )

Line 5089: FROM pay_payroll_actions ppa

5085: AND pus.status = 'C';
5086:
5087: CURSOR csr_arch_exists IS
5088: SELECT 'Y'
5089: FROM pay_payroll_actions ppa
5090: WHERE ppa.report_type = 'SS_ARCHIVE'
5091: AND ppa.report_qualifier = 'SS_ARCHIVE'
5092: AND ppa.report_category = 'RT'
5093: AND ppa.business_group_id = p_business_group_id;