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_24QC_ARCHIVE dependencies on FND_PROFILE

Line 555: AND asg.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')

551: ,per_periods_of_service pos
552: WHERE asg.person_id = pos.person_id
553: AND asg.assignment_id = p_assignment_id
554: AND asg.business_group_id = pos.business_group_id
555: AND asg.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
556: AND NVL(pos.actual_termination_date,(TO_DATE('31-12-4712','DD-MM-YYYY')))
557: BETWEEN asg.effective_start_date AND asg.effective_end_date
558: ORDER BY 1 DESC;
559:

Line 983: AND hou.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')

979: FROM hr_organization_information hoi
980: ,hr_organization_units hou
981: WHERE hoi.organization_id = g_gre_id
982: AND hoi.organization_id = hou.organization_id
983: AND hou.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
984: AND hoi.org_information_context = 'PER_IN_IT_CHALLAN_INFO'
985: AND hoi.org_information1 = g_tax_year
986: AND hoi.org_information13 = g_quarter
987: )

Line 1008: AND hou.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')

1004: FROM hr_organization_information hoi
1005: ,hr_organization_units hou
1006: WHERE hoi.organization_id = g_gre_id
1007: AND hoi.organization_id = hou.organization_id
1008: AND hou.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
1009: AND hoi.org_information_context = 'PER_IN_IT_CHALLAN_INFO'
1010: AND hoi.org_information1 = g_tax_year
1011: AND hoi.org_information13 = g_quarter
1012: AND hoi.org_information6 = 'C'

Line 1041: AND hou.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')

1037: FROM hr_organization_information hoi
1038: ,hr_organization_units hou
1039: WHERE hoi.organization_id = g_gre_id
1040: AND hoi.organization_id = hou.organization_id
1041: AND hou.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
1042: AND hoi.org_information_context = 'PER_IN_IT_CHALLAN_INFO'
1043: AND hoi.org_information1 = g_tax_year
1044: AND hoi.org_information13 = g_quarter
1045: AND hoi.org_information6 = 'C'

Line 1076: AND asg.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')

1072: AND paa.payroll_action_id = p_payroll_action_id
1073: AND asg.assignment_id = pai.assignment_id
1074: AND asg.person_id = pep.person_id
1075: AND asg.business_group_id = pep.business_group_id
1076: AND asg.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
1077: AND (
1078: (
1079: (NVL(pai.action_information13,'0') <> (SELECT NVL(paei.aei_information2,'0')
1080: FROM per_assignment_extra_info paei

Line 1184: AND asg.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')

1180: AND pai.action_context_id = p_assignment_action_id
1181: AND asg.assignment_id = pai.assignment_id
1182: AND asg.person_id = pep.person_id
1183: AND asg.business_group_id = pep.business_group_id
1184: AND asg.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
1185: AND (
1186: (NVL(pai.action_information18,'0') <> (SELECT NVL(paei.aei_information2,'0')
1187: FROM per_assignment_extra_info paei
1188: ,per_assignments_f paa

Line 1241: AND asg.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')

1237: AND pai.action_context_id = p_assignment_action_id
1238: AND asg.assignment_id = pai.assignment_id
1239: AND asg.person_id = pep.person_id
1240: AND asg.business_group_id = pep.business_group_id
1241: AND asg.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
1242: AND (
1243: (NVL(pai.action_information18,'0') = (SELECT NVL(paei.aei_information2,'0')
1244: FROM per_assignment_extra_info paei
1245: ,per_assignments_f paa

Line 1368: WHERE business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')

1364: CURSOR c_bg_check(p_assignment_id NUMBER)
1365: IS
1366: SELECT 1
1367: FROM per_assignments_f
1368: WHERE business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
1369: AND assignment_id = p_assignment_id;
1370:
1371: l_procedure VARCHAR2(100);
1372: l_action_id NUMBER;

Line 1964: AND asg.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')

1960: AND paa.payroll_action_id = p_payroll_action_id
1961: AND asg.assignment_id = pai.assignment_id
1962: AND asg.person_id = pep.person_id
1963: AND asg.business_group_id = pep.business_group_id
1964: AND asg.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
1965: AND pai.source_id IN
1966: (
1967: SELECT
1968: paa.assignment_action_id run_asg_action_id

Line 2144: AND asg.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')

2140: AND pai.action_context_id = p_assignment_action_id
2141: AND asg.assignment_id = pai.assignment_id
2142: AND asg.person_id = pep.person_id
2143: AND asg.business_group_id = pep.business_group_id
2144: AND asg.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
2145: AND pai.source_id IN
2146: (
2147: SELECT
2148: paa.assignment_action_id run_asg_action_id

Line 2275: AND asg.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')

2271: AND pai.action_context_id = p_assignment_action_id
2272: AND asg.assignment_id = pai.assignment_id
2273: AND asg.person_id = pep.person_id
2274: AND asg.business_group_id = pep.business_group_id
2275: AND asg.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
2276: AND (
2277: (FND_NUMBER.CANONICAL_TO_NUMBER(remove_curr_format(get_24Q_values('IN_24QC_SALARY','F16 Salary Under Section 17',pai.action_context_id,pai.source_id,1)))
2278: = FND_NUMBER.CANONICAL_TO_NUMBER(remove_curr_format(pay_in_tax_utils.get_balance_value(pai.source_id,'F16 Salary Under Section 17','_ASG_LE_PTD','TAX_UNIT_ID',g_gre_id))))
2279: AND

Line 2462: WHERE business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')

2458: CURSOR c_bg_check(p_assignment_id NUMBER)
2459: IS
2460: SELECT 1
2461: FROM per_assignments_f
2462: WHERE business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
2463: AND assignment_id = p_assignment_id;
2464:
2465: l_procedure VARCHAR2(100);
2466: l_action_id NUMBER;

Line 2732: AND hou.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')

2728: ,hr_organization_units hou
2729: WHERE hoi.organization_id = p_gre_id
2730: AND hoi.org_information_context = 'PER_IN_INCOME_TAX_DF'
2731: AND hou.organization_id = hoi.organization_id
2732: AND hou.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
2733: AND g_qr_end_date BETWEEN hou.date_from AND NVL(hou.date_to,TO_DATE('31-12-4712','DD-MM-YYYY'));
2734:
2735: CURSOR c_reg_org_details(p_reg_org_id NUMBER)
2736: IS

Line 2744: AND hou.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')

2740: ,hr_organization_units hou
2741: WHERE hoi.organization_id = p_reg_org_id
2742: AND hoi.org_information_context = 'PER_IN_COMPANY_DF'
2743: AND hou.organization_id = hoi.organization_id
2744: AND hou.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
2745: AND g_qr_end_date BETWEEN hou.date_from AND NVL(hou.date_to,TO_DATE('31-12-4712','DD-MM-YYYY'));
2746:
2747: CURSOR c_pos(p_person_id NUMBER)
2748: IS

Line 2757: AND asg.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')

2753: WHERE asg.position_id=pos.position_id(+)
2754: AND asg.job_id=job.job_id(+)
2755: AND asg.person_id = p_person_id
2756: AND asg.primary_flag = 'Y'
2757: AND asg.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
2758: AND g_qr_end_date BETWEEN pos.date_effective(+) AND NVL(pos.date_end(+),TO_DATE('31-12-4712','DD-MM-YYYY'))
2759: AND g_qr_end_date BETWEEN job.date_from(+) AND NVL(job.date_to(+),TO_DATE('31-12-4712','DD-MM-YYYY'))
2760: AND g_qr_end_date BETWEEN asg.effective_start_date AND asg.effective_end_date;
2761:

Line 2770: AND asg.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')

2766: FROM per_assignments_f asg
2767: ,hr_organization_units hou
2768: WHERE asg.person_id = p_person_id
2769: AND asg.primary_flag = 'Y'
2770: AND asg.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
2771: AND hou.organization_id = asg.organization_id
2772: AND hou.business_group_id = asg.business_group_id
2773: AND g_qr_end_date BETWEEN asg.effective_start_date AND asg.effective_end_date
2774: AND g_qr_end_date BETWEEN hou.date_from AND NVL(hou.date_to,TO_DATE('31-12-4712','DD-MM-YYYY'));

Line 2787: AND hou.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')

2783: ,per_people_f pep
2784: WHERE hoi.org_information_context = 'PER_IN_INCOME_TAX_REP_DF'
2785: AND hoi.organization_id = p_gre_id
2786: AND hou.organization_id = hoi.organization_id
2787: AND hou.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
2788: AND pep.person_id = hoi.org_information1
2789: AND pep.business_group_id = hou.business_group_id
2790: AND g_qr_end_date BETWEEN pep.effective_start_date AND pep.effective_end_date
2791: AND g_qr_end_date BETWEEN fnd_date.canonical_to_date(hoi.org_information2)

Line 3218: AND hou.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')

3214: FROM hr_organization_information hoi
3215: ,hr_organization_units hou
3216: WHERE hoi.organization_id = p_gre_id
3217: AND hoi.organization_id = hou.organization_id
3218: AND hou.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
3219: AND org_information_context = 'PER_IN_IT_CHALLAN_INFO'
3220: )
3221: AND hoi.org_information13 = g_quarter
3222: AND hoi.org_information1 = p_tax_year

Line 3260: AND hou.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')

3256: FROM hr_organization_information hoi
3257: ,hr_organization_units hou
3258: WHERE hoi.organization_id = p_gre_id
3259: AND hoi.organization_id = hou.organization_id
3260: AND hou.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
3261: AND org_information_context = 'PER_IN_IT_CHALLAN_INFO'
3262: )
3263: AND hoi.org_information13 = g_quarter
3264: AND hoi.org_information1 = p_tax_year

Line 3890: AND pep.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')

3886: FROM per_assignments_f asg
3887: ,per_people_f pep
3888: WHERE asg.assignment_id = p_assignment_id
3889: AND pep.person_id = asg.person_id
3890: AND pep.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
3891: AND asg.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
3892: AND assignment_end_date(asg.assignment_id) BETWEEN asg.effective_start_date AND asg.effective_end_date
3893: AND assignment_end_date(asg.assignment_id) BETWEEN pep.effective_start_date AND pep.effective_end_date
3894: ORDER BY 5 DESC;

Line 3891: AND asg.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')

3887: ,per_people_f pep
3888: WHERE asg.assignment_id = p_assignment_id
3889: AND pep.person_id = asg.person_id
3890: AND pep.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
3891: AND asg.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
3892: AND assignment_end_date(asg.assignment_id) BETWEEN asg.effective_start_date AND asg.effective_end_date
3893: AND assignment_end_date(asg.assignment_id) BETWEEN pep.effective_start_date AND pep.effective_end_date
3894: ORDER BY 5 DESC;
3895:

Line 4308: AND pep.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')

4304: FROM per_assignments_f asg
4305: ,per_people_f pep
4306: WHERE asg.assignment_id = p_assignment_id
4307: AND pep.person_id = asg.person_id
4308: AND pep.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
4309: AND asg.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
4310: AND assignment_end_date(asg.assignment_id) BETWEEN asg.effective_start_date AND asg.effective_end_date
4311: AND assignment_end_date(asg.assignment_id) BETWEEN pep.effective_start_date AND pep.effective_end_date;
4312:

Line 4309: AND asg.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')

4305: ,per_people_f pep
4306: WHERE asg.assignment_id = p_assignment_id
4307: AND pep.person_id = asg.person_id
4308: AND pep.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
4309: AND asg.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
4310: AND assignment_end_date(asg.assignment_id) BETWEEN asg.effective_start_date AND asg.effective_end_date
4311: AND assignment_end_date(asg.assignment_id) BETWEEN pep.effective_start_date AND pep.effective_end_date;
4312:
4313: CURSOR c_24qc_source_id(p_action_context_id NUMBER,

Line 4383: AND asg.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')

4379: AND scl.segment1 LIKE g_gre_id
4380: AND ( asg.effective_start_date BETWEEN g_fin_start_date AND g_end_date
4381: OR g_fin_start_date BETWEEN asg.effective_start_date AND asg.effective_end_date
4382: )
4383: AND asg.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
4384: ORDER BY 1 ;
4385:
4386: CURSOR get_eoy_archival_details(p_start_date DATE
4387: ,p_end_date DATE

Line 4440: AND asg.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')

4436: ,per_periods_of_service pos
4437: WHERE asg.person_id = pos.person_id
4438: AND asg.assignment_id = p_assignment_id
4439: AND asg.business_group_id = pos.business_group_id
4440: AND asg.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
4441: AND NVL(pos.actual_termination_date,(to_date('31-12-4712','DD-MM-YYYY')))
4442: BETWEEN asg.effective_start_date AND asg.effective_end_date
4443: ORDER BY 1 DESC;
4444:

Line 6926: AND hou.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')

6922: FROM hr_organization_information hoi
6923: ,hr_organization_units hou
6924: WHERE hoi.organization_id = g_gre_id
6925: AND hoi.organization_id = hou.organization_id
6926: AND hou.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
6927: AND org_information_context = 'PER_IN_IT_CHALLAN_INFO'
6928: )
6929: AND hoi.org_information13 = g_quarter
6930: AND hoi.org_information1 = g_tax_year;

Line 7120: AND hou.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')

7116: FROM hr_organization_information hoi
7117: ,hr_organization_units hou
7118: WHERE hoi.organization_id = g_gre_id
7119: AND hoi.organization_id = hou.organization_id
7120: AND hou.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
7121: AND org_information_context = 'PER_IN_IT_CHALLAN_INFO'
7122: )
7123: AND hoi.org_information13 = g_quarter
7124: AND hoi.org_information1 = g_tax_year