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_GB_RTI_EAS dependencies on DUAL

Line 500: || 'FROM DUAL';

496: l_sqlstr :=
497: 'SELECT '
498: || l_package
499: || ' (:p_assignment_id,:p_eff_date) '
500: || 'FROM DUAL';
501: EXECUTE IMMEDIATE l_sqlstr into l_expat_indicator USING p_assignment_id,p_effective_start_date;
502:
503: hr_utility.trace('Function value l_expat_indicator '||l_expat_indicator);
504:

Line 643: || 'FROM DUAL';

639: l_sqlstr :=
640: 'SELECT '
641: || l_package
642: || ' (:p_assignment_id,:p_eff_date) '
643: || 'FROM DUAL';
644: EXECUTE IMMEDIATE l_sqlstr into l_occ_pension_indicator USING p_assignment_id,p_effective_start_date;
645:
646: hr_utility.trace('Function value l_occ_pension_indicator '||l_occ_pension_indicator);
647:

Line 786: || 'FROM DUAL';

782: l_sqlstr :=
783: 'SELECT '
784: || l_package
785: || ' (:p_assignment_id,:p_eff_date) '
786: || 'FROM DUAL';
787: EXECUTE IMMEDIATE l_sqlstr into l_pay_non_indiv_ind USING p_assignment_id,p_effective_start_date;
788:
789: hr_utility.trace('Function value l_pay_non_indiv_ind '||l_pay_non_indiv_ind);
790:

Line 886: from dual;

882: cursor get_agg_start_end_dates is
883: select
884: pay_gb_eoy_archive.get_agg_active_start(p_person_rec.assignment_id,l_tax_ref,l_effective_date) start_date,
885: pay_gb_eoy_archive.get_agg_active_end(p_person_rec.assignment_id,l_tax_ref,l_effective_date) end_date
886: from dual;
887:
888: cursor csr_get_irregular_details is
889: SELECT AEI_INFORMATION3
890: FROM PER_ASSIGNMENT_EXTRA_INFO

Line 1255: populate_run_msg(p_assactid,'The Payment to a Non-Individual indicator for the assignment ' || l_assignment_number || ' is invalid. Verify and submit a valid Payment to a Non-Individual indicator.');

1251: END IF;
1252:
1253: IF ((l_pay_non_indiv_ind <> ' ' and l_pay_non_indiv_ind IS NOT NULL)
1254: and l_pay_non_indiv_ind <> 'Y') then
1255: populate_run_msg(p_assactid,'The Payment to a Non-Individual indicator for the assignment ' || l_assignment_number || ' is invalid. Verify and submit a valid Payment to a Non-Individual indicator.');
1256: fnd_file.put_line (fnd_file.LOG,'The Payment to a Non-Individual indicator for the assignment ' || l_assignment_number || ' is invalid. Verify and submit a valid Payment to a Non-Individual indicator.');
1257: edi_validation_fail := 'Y';
1258: END IF; */
1259:

Line 1256: fnd_file.put_line (fnd_file.LOG,'The Payment to a Non-Individual indicator for the assignment ' || l_assignment_number || ' is invalid. Verify and submit a valid Payment to a Non-Individual indicator.');

1252:
1253: IF ((l_pay_non_indiv_ind <> ' ' and l_pay_non_indiv_ind IS NOT NULL)
1254: and l_pay_non_indiv_ind <> 'Y') then
1255: populate_run_msg(p_assactid,'The Payment to a Non-Individual indicator for the assignment ' || l_assignment_number || ' is invalid. Verify and submit a valid Payment to a Non-Individual indicator.');
1256: fnd_file.put_line (fnd_file.LOG,'The Payment to a Non-Individual indicator for the assignment ' || l_assignment_number || ' is invalid. Verify and submit a valid Payment to a Non-Individual indicator.');
1257: edi_validation_fail := 'Y';
1258: END IF; */
1259:
1260: --Tax code

Line 1517: populate_run_msg(p_assactid,'Date of Birth present for a non_individual. Please remove and resubmit');

1513: END IF;
1514:
1515: /*
1516: IF ((l_date_of_birth IS not NULL) and (l_pay_non_indiv_ind <> ' ' or l_pay_non_indiv_ind IS not NULL)) THEN
1517: populate_run_msg(p_assactid,'Date of Birth present for a non_individual. Please remove and resubmit');
1518: fnd_file.put_line (fnd_file.LOG,'Date of Birth present for a non_individual. Please remove and resubmit');
1519: edi_validation_fail := 'Y';
1520: END IF;*/
1521:

Line 1518: fnd_file.put_line (fnd_file.LOG,'Date of Birth present for a non_individual. Please remove and resubmit');

1514:
1515: /*
1516: IF ((l_date_of_birth IS not NULL) and (l_pay_non_indiv_ind <> ' ' or l_pay_non_indiv_ind IS not NULL)) THEN
1517: populate_run_msg(p_assactid,'Date of Birth present for a non_individual. Please remove and resubmit');
1518: fnd_file.put_line (fnd_file.LOG,'Date of Birth present for a non_individual. Please remove and resubmit');
1519: edi_validation_fail := 'Y';
1520: END IF;*/
1521:
1522: IF ((l_date_of_birth > p_effective_date) OR (l_year1 > 130)) THEN

Line 2093: select 'Y' from dual where exists(select *

2089: function check_resubmission(pactid number,tax_ref varchar2,permit varchar2,bg_id number)
2090: return varchar2 is
2091: l_exists varchar2(1):='N';
2092: cursor get_prev_flag is
2093: select 'Y' from dual where exists(select *
2094: from pay_payroll_actions prev
2095: where prev.payroll_action_id <> pactid
2096: and prev.business_group_id =bg_id
2097: and prev.ACTION_STATUS='C'

Line 2596: from dual;

2592: -- Create one assignment action for every assignment
2593: hr_utility.set_location('Archiving for assignment_id '||asg_rec.assignment_id, 50);
2594: select pay_assignment_actions_s.nextval
2595: into lockingactid
2596: from dual;
2597:
2598: -- Insert assignment into pay_assignment_actions
2599: hr_nonrun_asact.insact
2600: (

Line 2655: from dual;

2651: -- Create one assignment action for every assignment
2652: hr_utility.set_location('Archiving for assignment_id '||asg_rec.assignment_id, 50);
2653: select pay_assignment_actions_s.nextval
2654: into lockingactid
2655: from dual;
2656:
2657: -- Insert assignment into pay_assignment_actions
2658: hr_nonrun_asact.insact
2659: (

Line 2816: from dual;

2812: -- Create one assignment action for every assignment
2813: hr_utility.set_location('Archiving for assignment_id '||asg_rec.assignment_id, 50);
2814: select pay_assignment_actions_s.nextval
2815: into lockingactid
2816: from dual;
2817:
2818: -- Insert assignment into pay_assignment_actions
2819: hr_nonrun_asact.insact
2820: (

Line 3185: populate_run_msg(p_assactid,'There are aggregated assignments for payment to a non-individual but indicators are not set across all assignments');

3181: end if;
3182: if(((l_prev_pay_non_indiv <> '' or l_prev_pay_non_indiv is not null)and (l_pay_non_indiv = '' or l_pay_non_indiv is null))
3183: or ((l_prev_pay_non_indiv = '' or l_prev_pay_non_indiv is null) and (l_pay_non_indiv <> '' or l_pay_non_indiv is not null))
3184: or ((l_prev_pay_non_indiv <> '' or l_prev_pay_non_indiv is not null)and (l_pay_non_indiv <> '' or l_pay_non_indiv is not null)and (l_prev_pay_non_indiv <> l_pay_non_indiv))) then
3185: populate_run_msg(p_assactid,'There are aggregated assignments for payment to a non-individual but indicators are not set across all assignments');
3186: fnd_file.put_line (fnd_file.LOG,'There are aggregated assignments for payment to a non-individual but indicators are not set across all assignments.');
3187: l_error :='Y';
3188: end if;
3189: if l_error = 'Y' then

Line 3186: fnd_file.put_line (fnd_file.LOG,'There are aggregated assignments for payment to a non-individual but indicators are not set across all assignments.');

3182: if(((l_prev_pay_non_indiv <> '' or l_prev_pay_non_indiv is not null)and (l_pay_non_indiv = '' or l_pay_non_indiv is null))
3183: or ((l_prev_pay_non_indiv = '' or l_prev_pay_non_indiv is null) and (l_pay_non_indiv <> '' or l_pay_non_indiv is not null))
3184: or ((l_prev_pay_non_indiv <> '' or l_prev_pay_non_indiv is not null)and (l_pay_non_indiv <> '' or l_pay_non_indiv is not null)and (l_prev_pay_non_indiv <> l_pay_non_indiv))) then
3185: populate_run_msg(p_assactid,'There are aggregated assignments for payment to a non-individual but indicators are not set across all assignments');
3186: fnd_file.put_line (fnd_file.LOG,'There are aggregated assignments for payment to a non-individual but indicators are not set across all assignments.');
3187: l_error :='Y';
3188: end if;
3189: if l_error = 'Y' then
3190: close fetch_all_paye_agg_asg;