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.PER_PL_ASSIGNMENT dependencies on PAY_PL_PAYE_DETAILS_F

Line 20: from pay_pl_paye_details_f

16: and r_date between effective_start_date and effective_end_date;
17:
18: cursor csr_check_paye_exists(r_join_variable in number,r_date date) is
19: select '1'
20: from pay_pl_paye_details_f
21: where per_or_asg_id=r_join_variable
22: and r_date between effective_start_date and effective_end_date;
23:
24: cursor csr_assgt_type(r_assignment_id number,r_date date) is

Line 838: l_object_version_number pay_pl_paye_details_f.object_version_number%type;

834:
835:
836: declare --declare2
837: l_paye_already char(1):='0';
838: l_object_version_number pay_pl_paye_details_f.object_version_number%type;
839: l_paye_details_id pay_pl_paye_details_f.paye_details_id%type;
840: l_effective_start_date pay_pl_paye_details_f.effective_start_date%type;
841: l_effective_end_date pay_pl_paye_details_f.effective_end_date%type;
842: l_effective_date_warning boolean;

Line 839: l_paye_details_id pay_pl_paye_details_f.paye_details_id%type;

835:
836: declare --declare2
837: l_paye_already char(1):='0';
838: l_object_version_number pay_pl_paye_details_f.object_version_number%type;
839: l_paye_details_id pay_pl_paye_details_f.paye_details_id%type;
840: l_effective_start_date pay_pl_paye_details_f.effective_start_date%type;
841: l_effective_end_date pay_pl_paye_details_f.effective_end_date%type;
842: l_effective_date_warning boolean;
843: l_person_id number(10);

Line 840: l_effective_start_date pay_pl_paye_details_f.effective_start_date%type;

836: declare --declare2
837: l_paye_already char(1):='0';
838: l_object_version_number pay_pl_paye_details_f.object_version_number%type;
839: l_paye_details_id pay_pl_paye_details_f.paye_details_id%type;
840: l_effective_start_date pay_pl_paye_details_f.effective_start_date%type;
841: l_effective_end_date pay_pl_paye_details_f.effective_end_date%type;
842: l_effective_date_warning boolean;
843: l_person_id number(10);
844: l_business_group_id number(10);

Line 841: l_effective_end_date pay_pl_paye_details_f.effective_end_date%type;

837: l_paye_already char(1):='0';
838: l_object_version_number pay_pl_paye_details_f.object_version_number%type;
839: l_paye_details_id pay_pl_paye_details_f.paye_details_id%type;
840: l_effective_start_date pay_pl_paye_details_f.effective_start_date%type;
841: l_effective_end_date pay_pl_paye_details_f.effective_end_date%type;
842: l_effective_date_warning boolean;
843: l_person_id number(10);
844: l_business_group_id number(10);
845:

Line 854: select '1' from pay_pl_paye_details_f

850: where assignment_id=p_assignment_id
851: and p_effective_date between effective_start_date and effective_end_date;
852:
853: cursor csr_paye_already_exists is
854: select '1' from pay_pl_paye_details_f
855: where contract_category='TERM_NORMAL'
856: and p_effective_date between effective_start_date and effective_end_date
857: and per_or_asg_id=p_assignment_id;
858:

Line 861: from pay_pl_paye_details_f

857: and per_or_asg_id=p_assignment_id;
858:
859: cursor csr_paye_details(r_person_id number) is
860: select tax_reduction,tax_calc_with_spouse_child,income_reduction,income_reduction_amount,rate_of_tax
861: from pay_pl_paye_details_f
862: where per_or_asg_id=r_person_id
863: and contract_category='NORMAL'
864: and p_effective_date between effective_start_date and effective_end_date;
865: l_csr_paye_details csr_paye_details%rowtype;

Line 1149: l_object_version_number pay_pl_paye_details_f.object_version_number%type;

1145: where assignment_id = p_assignment_id;
1146:
1147: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
1148:
1149: l_object_version_number pay_pl_paye_details_f.object_version_number%type;
1150: l_paye_details_id pay_pl_paye_details_f.paye_details_id%type;
1151: l_effective_start_date pay_pl_paye_details_f.effective_start_date%type;
1152: l_effective_end_date pay_pl_paye_details_f.effective_end_date%type;
1153: l_effective_date_warning boolean;

Line 1150: l_paye_details_id pay_pl_paye_details_f.paye_details_id%type;

1146:
1147: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
1148:
1149: l_object_version_number pay_pl_paye_details_f.object_version_number%type;
1150: l_paye_details_id pay_pl_paye_details_f.paye_details_id%type;
1151: l_effective_start_date pay_pl_paye_details_f.effective_start_date%type;
1152: l_effective_end_date pay_pl_paye_details_f.effective_end_date%type;
1153: l_effective_date_warning boolean;
1154: l_proc varchar2(30);

Line 1151: l_effective_start_date pay_pl_paye_details_f.effective_start_date%type;

1147: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
1148:
1149: l_object_version_number pay_pl_paye_details_f.object_version_number%type;
1150: l_paye_details_id pay_pl_paye_details_f.paye_details_id%type;
1151: l_effective_start_date pay_pl_paye_details_f.effective_start_date%type;
1152: l_effective_end_date pay_pl_paye_details_f.effective_end_date%type;
1153: l_effective_date_warning boolean;
1154: l_proc varchar2(30);
1155:

Line 1152: l_effective_end_date pay_pl_paye_details_f.effective_end_date%type;

1148:
1149: l_object_version_number pay_pl_paye_details_f.object_version_number%type;
1150: l_paye_details_id pay_pl_paye_details_f.paye_details_id%type;
1151: l_effective_start_date pay_pl_paye_details_f.effective_start_date%type;
1152: l_effective_end_date pay_pl_paye_details_f.effective_end_date%type;
1153: l_effective_date_warning boolean;
1154: l_proc varchar2(30);
1155:
1156: BEGIN

Line 1208: l_object_version_number pay_pl_paye_details_f.object_version_number%type;

1204: where paaf.soft_coding_keyflex_id = soft.soft_coding_keyflex_id
1205: and paaf.assignment_id = p_assignment_id
1206: and p_effective_date between paaf.effective_start_date and paaf.effective_end_date;
1207:
1208: l_object_version_number pay_pl_paye_details_f.object_version_number%type;
1209: l_paye_details_id pay_pl_paye_details_f.paye_details_id%type;
1210: l_effective_start_date pay_pl_paye_details_f.effective_start_date%type;
1211: l_effective_end_date pay_pl_paye_details_f.effective_end_date%type;
1212: l_effective_date_warning boolean;

Line 1209: l_paye_details_id pay_pl_paye_details_f.paye_details_id%type;

1205: and paaf.assignment_id = p_assignment_id
1206: and p_effective_date between paaf.effective_start_date and paaf.effective_end_date;
1207:
1208: l_object_version_number pay_pl_paye_details_f.object_version_number%type;
1209: l_paye_details_id pay_pl_paye_details_f.paye_details_id%type;
1210: l_effective_start_date pay_pl_paye_details_f.effective_start_date%type;
1211: l_effective_end_date pay_pl_paye_details_f.effective_end_date%type;
1212: l_effective_date_warning boolean;
1213: l_record_exists varchar2(1);

Line 1210: l_effective_start_date pay_pl_paye_details_f.effective_start_date%type;

1206: and p_effective_date between paaf.effective_start_date and paaf.effective_end_date;
1207:
1208: l_object_version_number pay_pl_paye_details_f.object_version_number%type;
1209: l_paye_details_id pay_pl_paye_details_f.paye_details_id%type;
1210: l_effective_start_date pay_pl_paye_details_f.effective_start_date%type;
1211: l_effective_end_date pay_pl_paye_details_f.effective_end_date%type;
1212: l_effective_date_warning boolean;
1213: l_record_exists varchar2(1);
1214: l_business_group_id pay_pl_paye_details_f.business_group_id%TYPE;

Line 1211: l_effective_end_date pay_pl_paye_details_f.effective_end_date%type;

1207:
1208: l_object_version_number pay_pl_paye_details_f.object_version_number%type;
1209: l_paye_details_id pay_pl_paye_details_f.paye_details_id%type;
1210: l_effective_start_date pay_pl_paye_details_f.effective_start_date%type;
1211: l_effective_end_date pay_pl_paye_details_f.effective_end_date%type;
1212: l_effective_date_warning boolean;
1213: l_record_exists varchar2(1);
1214: l_business_group_id pay_pl_paye_details_f.business_group_id%TYPE;
1215: l_segment3 hr_soft_coding_keyflex.segment3%TYPE;

Line 1214: l_business_group_id pay_pl_paye_details_f.business_group_id%TYPE;

1210: l_effective_start_date pay_pl_paye_details_f.effective_start_date%type;
1211: l_effective_end_date pay_pl_paye_details_f.effective_end_date%type;
1212: l_effective_date_warning boolean;
1213: l_record_exists varchar2(1);
1214: l_business_group_id pay_pl_paye_details_f.business_group_id%TYPE;
1215: l_segment3 hr_soft_coding_keyflex.segment3%TYPE;
1216: l_proc varchar2(19);
1217: cursor csr_paye_exists is
1218: select '1'

Line 1219: from pay_pl_paye_details_f

1215: l_segment3 hr_soft_coding_keyflex.segment3%TYPE;
1216: l_proc varchar2(19);
1217: cursor csr_paye_exists is
1218: select '1'
1219: from pay_pl_paye_details_f
1220: where per_or_asg_id = p_assignment_id
1221: and contract_category = l_segment3;
1222:
1223: BEGIN