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_IN_TAX_UTILS dependencies on HR_SOFT_CODING_KEYFLEX

Line 1141: l_current_gre hr_soft_coding_keyflex.segment1%type;

1137: l_ret_tax_hra_def_bal_id pay_defined_balances.defined_balance_id%type; -- Bug 11821281
1138: l_taxable_hra_def_bal_id pay_defined_balances.defined_balance_id%type;
1139: l_taxable_hra_ptd_bal_id pay_defined_balances.defined_balance_id%type;
1140: l_taxable_hra_proj_bal_id pay_defined_balances.defined_balance_id%type;
1141: l_current_gre hr_soft_coding_keyflex.segment1%type;
1142: l_gre hr_soft_coding_keyflex.segment1%type;
1143: l_entry_type_flag varchar2(2) ;
1144: l_entry_end_date DATE;
1145: l_check_date DATE;

Line 1142: l_gre hr_soft_coding_keyflex.segment1%type;

1138: l_taxable_hra_def_bal_id pay_defined_balances.defined_balance_id%type;
1139: l_taxable_hra_ptd_bal_id pay_defined_balances.defined_balance_id%type;
1140: l_taxable_hra_proj_bal_id pay_defined_balances.defined_balance_id%type;
1141: l_current_gre hr_soft_coding_keyflex.segment1%type;
1142: l_gre hr_soft_coding_keyflex.segment1%type;
1143: l_entry_type_flag varchar2(2) ;
1144: l_entry_end_date DATE;
1145: l_check_date DATE;
1146: l_terminate_date DATE;

Line 1152: FROM hr_soft_coding_keyflex scl

1148:
1149: CURSOR csr_get_current_gre( p_assignment_id per_all_assignments_f.assignment_id%type)
1150: IS
1151: SELECT scl.segment1
1152: FROM hr_soft_coding_keyflex scl
1153: ,per_all_assignments_f paf
1154: WHERE paf.assignment_id=p_assignment_id
1155: AND paf.SOFT_CODING_KEYFLEX_ID=scl.SOFT_CODING_KEYFLEX_ID
1156: AND p_effective_date BETWEEN paf.effective_start_date AND paf.effective_end_date;

Line 1163: FROM hr_soft_coding_keyflex scl,

1159: ,p_check_date DATE)
1160: IS
1161: SELECT scl.segment1
1162: ,paf.effective_start_date
1163: FROM hr_soft_coding_keyflex scl,
1164: per_all_assignments_f paf
1165: WHERE paf.assignment_id=p_assignment_id
1166: AND paf.SOFT_CODING_KEYFLEX_ID=scl.SOFT_CODING_KEYFLEX_ID
1167: AND paf.effective_start_date BETWEEN p_effective_date AND p_check_date ;

Line 3156: ,hr_soft_coding_keyflex hsc

3152: SELECT hsc.segment2
3153: ,hsc.segment3
3154: ,hsc.segment4
3155: FROM per_assignments_f paf
3156: ,hr_soft_coding_keyflex hsc
3157: WHERE paf.assignment_id = p_assignment_id
3158: AND paf.soft_coding_keyflex_id = hsc.soft_coding_keyflex_id
3159: AND paf.business_group_id = p_business_group_id
3160: AND p_date BETWEEN paf.effective_start_date

Line 3163: l_segment2 hr_soft_coding_keyflex.segment1%TYPE;

3159: AND paf.business_group_id = p_business_group_id
3160: AND p_date BETWEEN paf.effective_start_date
3161: AND paf.effective_end_date;
3162:
3163: l_segment2 hr_soft_coding_keyflex.segment1%TYPE;
3164: l_segment3 hr_soft_coding_keyflex.segment1%TYPE;
3165: l_segment4 hr_soft_coding_keyflex.segment1%TYPE;
3166: l_message VARCHAR2(255);
3167: l_procedure VARCHAR2(100);

Line 3164: l_segment3 hr_soft_coding_keyflex.segment1%TYPE;

3160: AND p_date BETWEEN paf.effective_start_date
3161: AND paf.effective_end_date;
3162:
3163: l_segment2 hr_soft_coding_keyflex.segment1%TYPE;
3164: l_segment3 hr_soft_coding_keyflex.segment1%TYPE;
3165: l_segment4 hr_soft_coding_keyflex.segment1%TYPE;
3166: l_message VARCHAR2(255);
3167: l_procedure VARCHAR2(100);
3168:

Line 3165: l_segment4 hr_soft_coding_keyflex.segment1%TYPE;

3161: AND paf.effective_end_date;
3162:
3163: l_segment2 hr_soft_coding_keyflex.segment1%TYPE;
3164: l_segment3 hr_soft_coding_keyflex.segment1%TYPE;
3165: l_segment4 hr_soft_coding_keyflex.segment1%TYPE;
3166: l_message VARCHAR2(255);
3167: l_procedure VARCHAR2(100);
3168:
3169: BEGIN

Line 3233: , hr_soft_coding_keyflex scl

3229:
3230: CURSOR csr_asg_start IS
3231: SELECT MAX(asg.effective_end_date) + 1
3232: FROM per_all_assignments_f asg
3233: , hr_soft_coding_keyflex scl
3234: WHERE asg.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
3235: AND nvl(scl.segment1,'-1')<> TO_CHAR(p_tax_unit_id)
3236: AND asg.assignment_id = p_assignment_id
3237: AND asg.effective_end_date < p_effective_date;

Line 3243: , hr_soft_coding_keyflex scl

3239: CURSOR csr_asg_start_le
3240: IS
3241: select min(asg.effective_start_date)
3242: from per_all_assignments_f asg
3243: , hr_soft_coding_keyflex scl
3244: WHERE asg.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
3245: AND scl.segment1 = TO_CHAR(p_tax_unit_id)
3246: AND asg.assignment_id = p_assignment_id
3247: AND asg.effective_start_date < p_effective_date;

Line 3319: , hr_soft_coding_keyflex scl

3315:
3316: CURSOR csr_asg_end IS
3317: SELECT MIN(asg.effective_start_date) -1
3318: FROM per_all_assignments_f asg
3319: , hr_soft_coding_keyflex scl
3320: WHERE asg.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
3321: AND NVL(scl.segment1,'-1')<> TO_CHAR(p_tax_unit_id)
3322: AND asg.assignment_id = p_assignment_id
3323: AND asg.effective_start_date > p_effective_date;

Line 3329: , hr_soft_coding_keyflex scl

3325: CURSOR csr_asg_end_le
3326: IS
3327: select max(asg.effective_end_date)
3328: from per_all_assignments_f asg
3329: , hr_soft_coding_keyflex scl
3330: WHERE asg.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
3331: AND scl.segment1 = TO_CHAR(p_tax_unit_id)
3332: AND asg.assignment_id = p_assignment_id
3333: AND asg.effective_end_date >= p_effective_date;

Line 4388: hr_soft_coding_keyflex scl

4384:
4385: CURSOR csr_cyclic_gre(p_start_date DATE,p_pre_le_end_date DATE) IS
4386: SELECT 1
4387: FROM per_assignments_f paf,
4388: hr_soft_coding_keyflex scl
4389: WHERE paf.assignment_id = p_assignment_id
4390: AND scl.segment1 = TO_CHAR(p_tax_unit_id)
4391: AND paf.SOFT_CODING_KEYFLEX_ID=scl.SOFT_CODING_KEYFLEX_ID
4392: AND paf.effective_end_date BETWEEN p_start_date AND p_pre_le_end_date;