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 4107: ,pay_assignment_actions paa

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

Line 4142: ,pay_assignment_actions paa_prev

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

Line 4215: ,pay_assignment_actions paa

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

Line 4247: ,pay_assignment_actions paa_prev

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

Line 4300: ,pay_assignment_actions paa

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

Line 4332: ,pay_assignment_actions paa_prev

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

Line 4489: SELECT pay_assignment_actions_s.nextval

4485: ln_step := 6;
4486: hr_utility_trace('--> Step 6' );
4487: hr_utility_trace('IMPLEMENTATION TRUE');
4488:
4489: SELECT pay_assignment_actions_s.nextval
4490: INTO ln_asg_act_id
4491: FROM dual;
4492:
4493: hr_utility_trace('--> Inserting into pay_assignment_actions' );

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

4489: SELECT pay_assignment_actions_s.nextval
4490: INTO ln_asg_act_id
4491: FROM dual;
4492:
4493: hr_utility_trace('--> Inserting into pay_assignment_actions' );
4494: hr_utility_trace('--> ln_asg_act_id' || ln_asg_act_id );
4495: -- insert into pay_assignment_actions.
4496: hr_nonrun_asact.insact(ln_asg_act_id,
4497: ln_assignment_id,

Line 4495: -- insert into pay_assignment_actions.

4491: FROM dual;
4492:
4493: hr_utility_trace('--> Inserting into pay_assignment_actions' );
4494: hr_utility_trace('--> ln_asg_act_id' || ln_asg_act_id );
4495: -- insert into pay_assignment_actions.
4496: hr_nonrun_asact.insact(ln_asg_act_id,
4497: ln_assignment_id,
4498: p_payroll_action_id,
4499: p_chunk,

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

4508: hr_utility_trace('ln_tax_unit_id = ' || ln_gre_id);
4509:
4510: hr_utility.set_location(gv_package || lv_procedure_name, 80);
4511:
4512: hr_utility_trace('--> Updating into pay_assignment_actions' );
4513: hr_utility_trace('--> ln_asg_act_id' || ln_asg_act_id );
4514: UPDATE pay_assignment_actions
4515: SET serial_number = to_char(ln_person_id) || '|' ||
4516: 'MX_IDWV=' || lv_report_mode || '|'

Line 4514: UPDATE pay_assignment_actions

4510: hr_utility.set_location(gv_package || lv_procedure_name, 80);
4511:
4512: hr_utility_trace('--> Updating into pay_assignment_actions' );
4513: hr_utility_trace('--> ln_asg_act_id' || ln_asg_act_id );
4514: UPDATE pay_assignment_actions
4515: SET serial_number = to_char(ln_person_id) || '|' ||
4516: 'MX_IDWV=' || lv_report_mode || '|'
4517: WHERE assignment_action_id = ln_asg_act_id;
4518:

Line 4561: SELECT pay_assignment_actions_s.nextval

4557: ln_person_id,
4558: fnd_date.canonical_to_date(lv_end_date),
4559: fnd_date.canonical_to_date(lv_start_date)) = 'Y') THEN
4560: hr_utility_trace('--> Inside If ' );
4561: SELECT pay_assignment_actions_s.nextval
4562: INTO ln_asg_act_id
4563: FROM dual;
4564:
4565: hr_utility_trace('--> insert into pay_assignment_actions.' );

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

4561: SELECT pay_assignment_actions_s.nextval
4562: INTO ln_asg_act_id
4563: FROM dual;
4564:
4565: hr_utility_trace('--> insert into pay_assignment_actions.' );
4566: -- insert into pay_assignment_actions.
4567: hr_nonrun_asact.insact(ln_asg_act_id,
4568: ln_assignment_id,
4569: p_payroll_action_id,

Line 4566: -- insert into pay_assignment_actions.

4562: INTO ln_asg_act_id
4563: FROM dual;
4564:
4565: hr_utility_trace('--> insert into pay_assignment_actions.' );
4566: -- insert into pay_assignment_actions.
4567: hr_nonrun_asact.insact(ln_asg_act_id,
4568: ln_assignment_id,
4569: p_payroll_action_id,
4570: p_chunk,

Line 4582: UPDATE pay_assignment_actions

4578: hr_utility_trace('ln_tax_unit_id = ' || ln_gre_id);
4579:
4580: hr_utility.set_location(gv_package || lv_procedure_name, 100);
4581:
4582: UPDATE pay_assignment_actions
4583: SET serial_number = to_char(ln_person_id) || '|' ||
4584: 'MX_IDWV=' || lv_report_mode || '|'
4585: WHERE assignment_action_id = ln_asg_act_id;
4586:

Line 4646: FROM pay_assignment_actions paa

4642: ,paa.assignment_id
4643: ,paa.tax_unit_id
4644: ,paa.chunk_number
4645: ,paa.serial_number
4646: FROM pay_assignment_actions paa
4647: WHERE paa.assignment_action_id = cp_assignment_action;
4648:
4649:
4650: CURSOR c_check_pay_action( cp_payroll_action_id IN NUMBER) IS