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_ASSIGNMENT_ACTIONS

Line 4240: ,pay_assignment_actions paa

4236: select 'Y'
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

Line 4265: ,pay_assignment_actions paa_prev

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'
4269: AND pay_mx_utility.get_legi_param_val('GRE',

Line 4546: ,pay_assignment_actions paa

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
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

Line 4578: ,pay_assignment_actions paa_prev

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'
4582: AND pay_mx_utility.get_legi_param_val('GRE',

Line 4631: ,pay_assignment_actions paa

4627: ,pay_population_ranges ppr
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

Line 4663: ,pay_assignment_actions paa_prev

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'
4667: AND pay_mx_utility.get_legi_param_val('GRE',

Line 4956: SELECT pay_assignment_actions_s.nextval

4952: ln_step := 6;
4953: hr_utility_trace('--> Step 6' );
4954: hr_utility_trace('IMPLEMENTATION TRUE');
4955:
4956: SELECT pay_assignment_actions_s.nextval
4957: INTO ln_asg_act_id
4958: FROM dual;
4959:
4960: hr_utility_trace('--> Inserting into pay_assignment_actions' );

Line 4960: hr_utility_trace('--> Inserting into pay_assignment_actions' );

4956: SELECT pay_assignment_actions_s.nextval
4957: INTO ln_asg_act_id
4958: FROM dual;
4959:
4960: hr_utility_trace('--> Inserting into pay_assignment_actions' );
4961: hr_utility_trace('--> ln_asg_act_id' || ln_asg_act_id );
4962: -- insert into pay_assignment_actions.
4963: hr_nonrun_asact.insact(ln_asg_act_id,
4964: ln_assignment_id,

Line 4962: -- insert into pay_assignment_actions.

4958: FROM dual;
4959:
4960: hr_utility_trace('--> Inserting into pay_assignment_actions' );
4961: hr_utility_trace('--> ln_asg_act_id' || ln_asg_act_id );
4962: -- insert into pay_assignment_actions.
4963: hr_nonrun_asact.insact(ln_asg_act_id,
4964: ln_assignment_id,
4965: p_payroll_action_id,
4966: p_chunk,

Line 4979: hr_utility_trace('--> Updating into pay_assignment_actions' );

4975: hr_utility_trace('ln_tax_unit_id = ' || ln_gre_id);
4976:
4977: hr_utility.set_location(gv_package || lv_procedure_name, 80);
4978:
4979: hr_utility_trace('--> Updating into pay_assignment_actions' );
4980: hr_utility_trace('--> ln_asg_act_id' || ln_asg_act_id );
4981: UPDATE pay_assignment_actions
4982: SET serial_number = to_char(ln_person_id) || '|' ||
4983: 'MX_IDWV=' || lv_report_mode || '|'

Line 4981: UPDATE pay_assignment_actions

4977: hr_utility.set_location(gv_package || lv_procedure_name, 80);
4978:
4979: hr_utility_trace('--> Updating into pay_assignment_actions' );
4980: hr_utility_trace('--> ln_asg_act_id' || ln_asg_act_id );
4981: UPDATE pay_assignment_actions
4982: SET serial_number = to_char(ln_person_id) || '|' ||
4983: 'MX_IDWV=' || lv_report_mode || '|'
4984: WHERE assignment_action_id = ln_asg_act_id;
4985:

Line 5028: SELECT pay_assignment_actions_s.nextval

5024: ln_person_id,
5025: fnd_date.canonical_to_date(lv_end_date),
5026: fnd_date.canonical_to_date(lv_start_date)) = 'Y') THEN
5027: hr_utility_trace('--> Inside If ' );
5028: SELECT pay_assignment_actions_s.nextval
5029: INTO ln_asg_act_id
5030: FROM dual;
5031:
5032: hr_utility_trace('--> insert into pay_assignment_actions.' );

Line 5032: hr_utility_trace('--> insert into pay_assignment_actions.' );

5028: SELECT pay_assignment_actions_s.nextval
5029: INTO ln_asg_act_id
5030: FROM dual;
5031:
5032: hr_utility_trace('--> insert into pay_assignment_actions.' );
5033: -- insert into pay_assignment_actions.
5034: hr_nonrun_asact.insact(ln_asg_act_id,
5035: ln_assignment_id,
5036: p_payroll_action_id,

Line 5033: -- insert into pay_assignment_actions.

5029: INTO ln_asg_act_id
5030: FROM dual;
5031:
5032: hr_utility_trace('--> insert into pay_assignment_actions.' );
5033: -- insert into pay_assignment_actions.
5034: hr_nonrun_asact.insact(ln_asg_act_id,
5035: ln_assignment_id,
5036: p_payroll_action_id,
5037: p_chunk,

Line 5049: UPDATE pay_assignment_actions

5045: hr_utility_trace('ln_tax_unit_id = ' || ln_gre_id);
5046:
5047: hr_utility.set_location(gv_package || lv_procedure_name, 100);
5048:
5049: UPDATE pay_assignment_actions
5050: SET serial_number = to_char(ln_person_id) || '|' ||
5051: 'MX_IDWV=' || lv_report_mode || '|'
5052: WHERE assignment_action_id = ln_asg_act_id;
5053:

Line 5113: FROM pay_assignment_actions paa

5109: ,paa.assignment_id
5110: ,paa.tax_unit_id
5111: ,paa.chunk_number
5112: ,paa.serial_number
5113: FROM pay_assignment_actions paa
5114: WHERE paa.assignment_action_id = cp_assignment_action;
5115:
5116:
5117: CURSOR c_check_pay_action( cp_payroll_action_id IN NUMBER) IS