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_PPD_BUS dependencies on PAY_PL_PAYE_DETAILS_F

Line 31: , pay_pl_paye_details_f ppd

27: cursor csr_sec_grp is
28: select pbg.security_group_id,
29: pbg.legislation_code
30: from per_business_groups_perf pbg
31: , pay_pl_paye_details_f ppd
32: where ppd.paye_details_id = p_paye_details_id
33: and pbg.business_group_id = ppd.business_group_id;
34: --
35: -- Declare local variables

Line 101: , pay_pl_paye_details_f ppd

97: --
98: cursor csr_leg_code is
99: select pbg.legislation_code
100: from per_business_groups_perf pbg
101: , pay_pl_paye_details_f ppd
102: where ppd.paye_details_id = p_paye_details_id
103: and pbg.business_group_id = ppd.business_group_id;
104: --
105: -- Declare local variables

Line 731: (p_associated_column1 => 'PAY_PL_PAYE_DETAILS_F.CONTRACT_CATEGORY'

727: hr_utility.set_location(' Leaving:'|| l_proc, 20);
728: exception
729: when app_exception.application_exception then
730: if hr_multi_message.exception_add
731: (p_associated_column1 => 'PAY_PL_PAYE_DETAILS_F.CONTRACT_CATEGORY'
732: ) then
733: hr_utility.set_location(' Leaving:'|| l_proc, 30);
734: raise;
735: end if;

Line 824: (p_check_column1 => 'PAY_PL_PAYE_DETAILS_F.CONTRACT_CATEGORY'

820: ,p_argument_value => p_per_or_asg_id
821: );
822:
823: if hr_multi_message.no_exclusive_error
824: (p_check_column1 => 'PAY_PL_PAYE_DETAILS_F.CONTRACT_CATEGORY'
825: ,p_check_column2 => 'PAY_PL_PAYE_DETAILS_F.BUSINESS_GROUP_ID'
826: ,p_associated_column1 => 'PAY_PL_PAYE_DETAILS_F.PER_OR_ASG_ID') then
827:
828: -- Continue with valiadtion only if the columns

Line 825: ,p_check_column2 => 'PAY_PL_PAYE_DETAILS_F.BUSINESS_GROUP_ID'

821: );
822:
823: if hr_multi_message.no_exclusive_error
824: (p_check_column1 => 'PAY_PL_PAYE_DETAILS_F.CONTRACT_CATEGORY'
825: ,p_check_column2 => 'PAY_PL_PAYE_DETAILS_F.BUSINESS_GROUP_ID'
826: ,p_associated_column1 => 'PAY_PL_PAYE_DETAILS_F.PER_OR_ASG_ID') then
827:
828: -- Continue with valiadtion only if the columns
829: -- a) BUSINESS_GROUP_ID and

Line 826: ,p_associated_column1 => 'PAY_PL_PAYE_DETAILS_F.PER_OR_ASG_ID') then

822:
823: if hr_multi_message.no_exclusive_error
824: (p_check_column1 => 'PAY_PL_PAYE_DETAILS_F.CONTRACT_CATEGORY'
825: ,p_check_column2 => 'PAY_PL_PAYE_DETAILS_F.BUSINESS_GROUP_ID'
826: ,p_associated_column1 => 'PAY_PL_PAYE_DETAILS_F.PER_OR_ASG_ID') then
827:
828: -- Continue with valiadtion only if the columns
829: -- a) BUSINESS_GROUP_ID and
830: -- b) CONTRACT_CATEGORY are valid.

Line 873: (p_associated_column1 => 'PAY_PL_PAYE_DETAILS_F.PER_OR_ASG_ID'

869: hr_utility.set_location(' Leaving:'|| l_proc, 20);
870: exception
871: when app_exception.application_exception then
872: if hr_multi_message.exception_add
873: (p_associated_column1 => 'PAY_PL_PAYE_DETAILS_F.PER_OR_ASG_ID'
874: ) then
875: hr_utility.set_location(' Leaving:'|| l_proc, 30);
876: raise;
877: end if;

Line 926: (p_associated_column1 => 'PAY_PL_PAYE_DETAILS_F.BUSINESS_GROUP_ID'

922: hr_utility.set_location(' Leaving:'|| l_proc, 20);
923: exception
924: when app_exception.application_exception then
925: if hr_multi_message.exception_add
926: (p_associated_column1 => 'PAY_PL_PAYE_DETAILS_F.BUSINESS_GROUP_ID'
927: ) then
928: hr_utility.set_location(' Leaving:'|| l_proc, 30);
929: raise;
930: end if;

Line 974: (p_check_column1 => 'PAY_PL_PAYE_DETAILS_F.CONTRACT_CATEGORY'

970: close csr_contract_type;
971: end if;
972:
973: if hr_multi_message.no_exclusive_error
974: (p_check_column1 => 'PAY_PL_PAYE_DETAILS_F.CONTRACT_CATEGORY'
975: ,p_check_column2 => 'PAY_PL_PAYE_DETAILS_F.BUSINESS_GROUP_ID'
976: ,p_associated_column1 => 'PAY_PL_PAYE_DETAILS_F.RATE_OF_TAX') then
977:
978: --

Line 975: ,p_check_column2 => 'PAY_PL_PAYE_DETAILS_F.BUSINESS_GROUP_ID'

971: end if;
972:
973: if hr_multi_message.no_exclusive_error
974: (p_check_column1 => 'PAY_PL_PAYE_DETAILS_F.CONTRACT_CATEGORY'
975: ,p_check_column2 => 'PAY_PL_PAYE_DETAILS_F.BUSINESS_GROUP_ID'
976: ,p_associated_column1 => 'PAY_PL_PAYE_DETAILS_F.RATE_OF_TAX') then
977:
978: --
979: -- Continue with valiadtion only if the columns

Line 976: ,p_associated_column1 => 'PAY_PL_PAYE_DETAILS_F.RATE_OF_TAX') then

972:
973: if hr_multi_message.no_exclusive_error
974: (p_check_column1 => 'PAY_PL_PAYE_DETAILS_F.CONTRACT_CATEGORY'
975: ,p_check_column2 => 'PAY_PL_PAYE_DETAILS_F.BUSINESS_GROUP_ID'
976: ,p_associated_column1 => 'PAY_PL_PAYE_DETAILS_F.RATE_OF_TAX') then
977:
978: --
979: -- Continue with valiadtion only if the columns
980: -- a) BUSINESS_GROUP_ID and

Line 1056: -- in the table pay_pl_paye_details_f

1052: end if;
1053: elsif p_contract_category = 'LUMP' then
1054:
1055: -- For Contract types L01, L02, L03, L04, L09, L10, L11 we will not store the Rate of Tax
1056: -- in the table pay_pl_paye_details_f
1057: if l_contract_type not in ('L01','L02','L03','L04','L09','L10','L11') then
1058: if p_rate_of_tax > 100 or p_rate_of_tax < 0 then
1059: hr_utility.set_message(801,'PAY_375891_F_LUMP_RATE_OF_TAX');
1060: -- This message will be 'Ensure that you enter a valid tax rate for this employee.'

Line 1072: (p_associated_column1 => 'PAY_PL_PAYE_DETAILS_F.RATE_OF_TAX'

1068: hr_utility.set_location(' Leaving:'|| l_proc, 20);
1069: exception
1070: when app_exception.application_exception then
1071: if hr_multi_message.exception_add
1072: (p_associated_column1 => 'PAY_PL_PAYE_DETAILS_F.RATE_OF_TAX'
1073: ) then
1074: hr_utility.set_location(' Leaving:'|| l_proc, 30);
1075: raise;
1076: end if;

Line 1160: (p_associated_column1 => 'PAY_PL_PAYE_DETAILS_F.TAX_REDUCTION'

1156:
1157: exception
1158: when app_exception.application_exception then
1159: if hr_multi_message.exception_add
1160: (p_associated_column1 => 'PAY_PL_PAYE_DETAILS_F.TAX_REDUCTION'
1161: ) then
1162: hr_utility.set_location(' Leaving:'|| l_proc, 30);
1163: raise;
1164: end if;

Line 1245: (p_associated_column1 => 'PAY_PL_PAYE_DETAILS_F.TAX_CALC_WITH_SPOUSE_CHILD'

1241: hr_utility.set_location(' Leaving:'|| l_proc, 20);
1242: exception
1243: when app_exception.application_exception then
1244: if hr_multi_message.exception_add
1245: (p_associated_column1 => 'PAY_PL_PAYE_DETAILS_F.TAX_CALC_WITH_SPOUSE_CHILD'
1246: ) then
1247: hr_utility.set_location(' Leaving:'|| l_proc, 30);
1248: raise;
1249: end if;

Line 1328: (p_associated_column1 => 'PAY_PL_PAYE_DETAILS_F.INCOME_REDUCTION'

1324: hr_utility.set_location(' Leaving:'|| l_proc, 20);
1325: exception
1326: when app_exception.application_exception then
1327: if hr_multi_message.exception_add
1328: (p_associated_column1 => 'PAY_PL_PAYE_DETAILS_F.INCOME_REDUCTION'
1329: ) then
1330: hr_utility.set_location(' Leaving:'|| l_proc, 30);
1331: raise;
1332: end if;