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 825: l_current_gre hr_soft_coding_keyflex.segment1%type;

821: l_hri_entry_id pay_element_entries_f.element_entry_id%type;
822: l_taxable_hra_def_bal_id pay_defined_balances.defined_balance_id%type;
823: l_taxable_hra_ptd_bal_id pay_defined_balances.defined_balance_id%type;
824: l_taxable_hra_proj_bal_id pay_defined_balances.defined_balance_id%type;
825: l_current_gre hr_soft_coding_keyflex.segment1%type;
826: l_gre hr_soft_coding_keyflex.segment1%type;
827: l_entry_type_flag varchar2(2) ;
828: l_entry_end_date DATE;
829: l_check_date DATE;

Line 826: l_gre hr_soft_coding_keyflex.segment1%type;

822: l_taxable_hra_def_bal_id pay_defined_balances.defined_balance_id%type;
823: l_taxable_hra_ptd_bal_id pay_defined_balances.defined_balance_id%type;
824: l_taxable_hra_proj_bal_id pay_defined_balances.defined_balance_id%type;
825: l_current_gre hr_soft_coding_keyflex.segment1%type;
826: l_gre hr_soft_coding_keyflex.segment1%type;
827: l_entry_type_flag varchar2(2) ;
828: l_entry_end_date DATE;
829: l_check_date DATE;
830:

Line 835: FROM hr_soft_coding_keyflex scl

831:
832: CURSOR csr_get_current_gre( p_assignment_id per_all_assignments_f.assignment_id%type)
833: IS
834: SELECT scl.segment1
835: FROM hr_soft_coding_keyflex scl
836: ,per_all_assignments_f paf
837: WHERE paf.assignment_id=p_assignment_id
838: AND paf.SOFT_CODING_KEYFLEX_ID=scl.SOFT_CODING_KEYFLEX_ID
839: AND p_effective_date BETWEEN paf.effective_start_date AND paf.effective_end_date;

Line 846: FROM hr_soft_coding_keyflex scl,

842: ,p_check_date DATE)
843: IS
844: SELECT scl.segment1
845: ,paf.effective_start_date
846: FROM hr_soft_coding_keyflex scl,
847: per_all_assignments_f paf
848: WHERE paf.assignment_id=p_assignment_id
849: AND paf.SOFT_CODING_KEYFLEX_ID=scl.SOFT_CODING_KEYFLEX_ID
850: AND paf.effective_start_date BETWEEN p_effective_date AND p_check_date ;

Line 2720: ,hr_soft_coding_keyflex hsc

2716: SELECT hsc.segment2
2717: ,hsc.segment3
2718: ,hsc.segment4
2719: FROM per_assignments_f paf
2720: ,hr_soft_coding_keyflex hsc
2721: WHERE paf.assignment_id = p_assignment_id
2722: AND paf.soft_coding_keyflex_id = hsc.soft_coding_keyflex_id
2723: AND paf.business_group_id = p_business_group_id
2724: AND p_date BETWEEN paf.effective_start_date

Line 2727: l_segment2 hr_soft_coding_keyflex.segment1%TYPE;

2723: AND paf.business_group_id = p_business_group_id
2724: AND p_date BETWEEN paf.effective_start_date
2725: AND paf.effective_end_date;
2726:
2727: l_segment2 hr_soft_coding_keyflex.segment1%TYPE;
2728: l_segment3 hr_soft_coding_keyflex.segment1%TYPE;
2729: l_segment4 hr_soft_coding_keyflex.segment1%TYPE;
2730: l_message VARCHAR2(255);
2731: l_procedure VARCHAR2(100);

Line 2728: l_segment3 hr_soft_coding_keyflex.segment1%TYPE;

2724: AND p_date BETWEEN paf.effective_start_date
2725: AND paf.effective_end_date;
2726:
2727: l_segment2 hr_soft_coding_keyflex.segment1%TYPE;
2728: l_segment3 hr_soft_coding_keyflex.segment1%TYPE;
2729: l_segment4 hr_soft_coding_keyflex.segment1%TYPE;
2730: l_message VARCHAR2(255);
2731: l_procedure VARCHAR2(100);
2732:

Line 2729: l_segment4 hr_soft_coding_keyflex.segment1%TYPE;

2725: AND paf.effective_end_date;
2726:
2727: l_segment2 hr_soft_coding_keyflex.segment1%TYPE;
2728: l_segment3 hr_soft_coding_keyflex.segment1%TYPE;
2729: l_segment4 hr_soft_coding_keyflex.segment1%TYPE;
2730: l_message VARCHAR2(255);
2731: l_procedure VARCHAR2(100);
2732:
2733: BEGIN

Line 2797: , hr_soft_coding_keyflex scl

2793:
2794: CURSOR csr_asg_start IS
2795: SELECT MAX(asg.effective_end_date) + 1
2796: FROM per_all_assignments_f asg
2797: , hr_soft_coding_keyflex scl
2798: WHERE asg.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
2799: AND nvl(scl.segment1,'-1')<> TO_CHAR(p_tax_unit_id)
2800: AND asg.assignment_id = p_assignment_id
2801: AND asg.effective_end_date < p_effective_date;

Line 2807: , hr_soft_coding_keyflex scl

2803: CURSOR csr_asg_start_le
2804: IS
2805: select min(asg.effective_start_date)
2806: from per_all_assignments_f asg
2807: , hr_soft_coding_keyflex scl
2808: WHERE asg.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
2809: AND scl.segment1 = TO_CHAR(p_tax_unit_id)
2810: AND asg.assignment_id = p_assignment_id
2811: AND asg.effective_start_date < p_effective_date;

Line 2883: , hr_soft_coding_keyflex scl

2879:
2880: CURSOR csr_asg_end IS
2881: SELECT MIN(asg.effective_start_date) -1
2882: FROM per_all_assignments_f asg
2883: , hr_soft_coding_keyflex scl
2884: WHERE asg.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
2885: AND NVL(scl.segment1,'-1')<> TO_CHAR(p_tax_unit_id)
2886: AND asg.assignment_id = p_assignment_id
2887: AND asg.effective_start_date > p_effective_date;

Line 2893: , hr_soft_coding_keyflex scl

2889: CURSOR csr_asg_end_le
2890: IS
2891: select max(asg.effective_end_date)
2892: from per_all_assignments_f asg
2893: , hr_soft_coding_keyflex scl
2894: WHERE asg.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
2895: AND scl.segment1 = TO_CHAR(p_tax_unit_id)
2896: AND asg.assignment_id = p_assignment_id
2897: AND asg.effective_end_date >= p_effective_date;

Line 3335: hr_soft_coding_keyflex scl

3331:
3332: CURSOR csr_cyclic_gre(p_start_date DATE,p_pre_le_end_date DATE) IS
3333: SELECT 1
3334: FROM per_assignments_f paf,
3335: hr_soft_coding_keyflex scl
3336: WHERE paf.assignment_id = p_assignment_id
3337: AND scl.segment1 = TO_CHAR(p_tax_unit_id)
3338: AND paf.SOFT_CODING_KEYFLEX_ID=scl.SOFT_CODING_KEYFLEX_ID
3339: AND paf.effective_end_date BETWEEN p_start_date AND p_pre_le_end_date;