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.PQP_GB_PSI_FUNCTIONS dependencies on PER_ALL_ASSIGNMENTS_F

Line 238: FROM per_all_assignments_f

234: l_person_id NUMBER;
235: BEGIN
236: SELECT person_id
237: INTO l_person_id
238: FROM per_all_assignments_f
239: WHERE assignment_id = p_assignment_id
240: AND ROWNUM < 2;
241: RETURN l_person_id;
242: EXCEPTION

Line 2686: FROM per_all_assignments_f

2682: -- Cursor to get assignment details
2683: CURSOR csr_get_org_id(c_basic_date DATE)
2684: IS
2685: SELECT organization_id
2686: FROM per_all_assignments_f
2687: WHERE assignment_id = p_assignment_id
2688: AND c_basic_date BETWEEN effective_start_date
2689: AND effective_end_date;
2690:

Line 2719: FROM per_all_assignments_f

2715:
2716: CURSOR csr_get_max_asg_end_date
2717: IS
2718: SELECT max(effective_end_date)
2719: FROM per_all_assignments_f
2720: WHERE assignment_id = p_assignment_id;
2721:
2722: l_max_asg_end_date DATE;
2723: l_bas_ext_dfn_id NUMBER;

Line 2833: FROM per_all_assignments_f

2829: l_return VARCHAR2(20);
2830: CURSOR csr_get_assignment_number
2831: IS
2832: SELECT assignment_number
2833: FROM per_all_assignments_f
2834: WHERE assignment_id = g_assignment_id
2835: AND g_effective_date BETWEEN effective_start_date
2836: AND effective_end_date;
2837:

Line 4269: from per_all_assignments_f '||

4265:
4266: IF g_asg_membership_col IS NOT NULL THEN
4267: debug('g_asg_membership_col: '||g_asg_membership_col,40);
4268: /*l_query := 'select '||g_asg_membership_col||'
4269: from per_all_assignments_f '||
4270: 'where business_group_id = '||p_business_group_id||' '||
4271: 'and assignment_id = '||p_assignment_id||' '||
4272: 'and ASS_ATTRIBUTE_CATEGORY = '||''''||g_asg_membership_context||''''||
4273: 'and to_date('||''''||TO_CHAR(p_effective_date,'dd/mm/yyyy')||''''||

Line 4278: 'from per_all_assignments_f '||' '||

4274: ',''dd/mm/yyyy'')'||' between effective_start_date '||
4275: 'and effective_end_date';*/
4276: /* commented to use bind variable instead of parameter */
4277: /* l_query := 'select '||g_asg_membership_col||' '||
4278: 'from per_all_assignments_f '||' '||
4279: 'where business_group_id = '||p_business_group_id||' '||
4280: 'and assignment_id = '||p_assignment_id||' ';
4281: IF g_asg_membership_context <> 'Global Data Elements' THEN
4282: l_query := l_query||

Line 4294: l_query := 'select '||g_asg_membership_col||' '||'from per_all_assignments_f '||' '||

4290: debug('l_query: '||l_query,30);
4291: -- fetch the value of from the column name
4292: OPEN c_base_table FOR l_query; */
4293:
4294: l_query := 'select '||g_asg_membership_col||' '||'from per_all_assignments_f '||' '||
4295: 'where business_group_id = :p_business_group_id '||
4296: 'and assignment_id = :p_assignment_id '||
4297: 'and :p_effective_date between effective_start_date and effective_end_date ';
4298:

Line 4356: ,p_assignment_dtl OUT NOCOPY per_all_assignments_f%rowtype

4352: (p_business_group_id IN NUMBER
4353: ,p_effective_date IN DATE
4354: ,p_assignment_id IN NUMBER
4355: ,p_person_dtl OUT NOCOPY per_all_people_f%rowtype
4356: ,p_assignment_dtl OUT NOCOPY per_all_assignments_f%rowtype
4357: ) RETURN VARCHAR2 -- Y or N
4358: IS
4359:
4360: --

Line 4371: l_assignment_dtl per_all_assignments_f%rowtype;

4367: l_last_hire_date_indicator VARCHAR2(1) := NULL;
4368: l_person_id NUMBER;
4369:
4370: l_person_dtl per_all_people_f%rowtype;
4371: l_assignment_dtl per_all_assignments_f%rowtype;
4372: i NUMBER;
4373: l_index NUMBER;
4374: l_value NUMBER;
4375: l_pension_element_type_id NUMBER;

Line 5302: FROM per_all_assignments_f asg

5298: ,asg.effective_end_date effective_end_date
5299: ,asg.creation_date creation_date
5300: ,asg.assignment_status_type_id status_type_id
5301: ,' ' status_type
5302: FROM per_all_assignments_f asg
5303:
5304: WHERE asg.assignment_id = p_assignment_id
5305: AND (( p_effective_date BETWEEN asg.effective_start_date
5306: AND asg.effective_end_date )

Line 5428: l_curr_assg_dtls per_all_assignments_f%ROWTYPE;

5424: l_per_assg_status per_assignment_status_types.per_system_status%TYPE;
5425: l_curr_person_dtls per_all_people_f%ROWTYPE;
5426: -- this contains the person details on effective date
5427:
5428: l_curr_assg_dtls per_all_assignments_f%ROWTYPE;
5429: -- this contains the person details on effective date
5430: CURSOR csr_assignment_status
5431: (
5432: p_assignment_status_type_id NUMBER

Line 6575: ELSIF ( l_chg_table = 'PER_ALL_ASSIGNMENTS_F'

6571: ELSIF is_today_sal_end() = 'Y' THEN -- salary end => report all
6572: -- g_is_terminated := 'Y'; -- change termination status to 'Y'
6573: l_is_terminated := 'Y'; -- change termination status to 'Y'
6574: l_report_all := 'Y';
6575: ELSIF ( l_chg_table = 'PER_ALL_ASSIGNMENTS_F'
6576: AND l_chg_column_name = 'ASSIGNMENT_STATUS_TYPE_ID') THEN
6577:
6578: -- if the event is on assignment_status_type_id
6579: -- reject the event

Line 6840: IF l_chg_table = 'PER_ALL_ASSIGNMENTS_F'

6836: EXIT;
6837: END IF;
6838:
6839: -- check for changes on assignment status
6840: IF l_chg_table = 'PER_ALL_ASSIGNMENTS_F'
6841: AND (l_chg_column_name = 'ASSIGNMENT_STATUS_TYPE_ID'
6842: OR l_update_type = 'E') THEN
6843:
6844: IF PQP_GB_PSI_FUNCTIONS.chk_is_employee_a_leaver

Line 6879: END IF;--IF (l_chg_table = 'PER_ALL_ASSIGNMENTS_F'

6875: RETURN 'Y';
6876:
6877: END IF; --IF l_assignment_status <> 'PROCESS'
6878:
6879: END IF;--IF (l_chg_table = 'PER_ALL_ASSIGNMENTS_F'
6880:
6881: -- looping condition
6882: IF l_index = g_pay_proc_evt_tab.LAST THEN
6883: EXIT;

Line 6913: IF (l_chg_table = 'PER_ALL_ASSIGNMENTS_F'

6909: l_chg_column_name := ben_ext_person.g_chg_pay_column;
6910: l_chg_table := ben_ext_person.g_chg_pay_table;
6911:
6912: -- check for changes on assignment status
6913: IF (l_chg_table = 'PER_ALL_ASSIGNMENTS_F'
6914: AND l_chg_column_name = 'ASSIGNMENT_STATUS_TYPE_ID') THEN
6915:
6916: debug('Returning Y for the event on assignment_status_type_id');
6917: debug_exit(l_proc);

Line 6920: END IF; --IF (l_chg_table = 'PER_ALL_ASSIGNMENTS_F'

6916: debug('Returning Y for the event on assignment_status_type_id');
6917: debug_exit(l_proc);
6918: RETURN 'Y';
6919:
6920: END IF; --IF (l_chg_table = 'PER_ALL_ASSIGNMENTS_F'
6921:
6922: debug('Returning N');
6923: debug_exit(l_proc);
6924: return 'N';

Line 6962: IF l_chg_table = 'PER_ALL_ASSIGNMENTS_F' THEN

6958: EXIT;
6959: END IF; --IF g_effective_date
6960:
6961: -- check for changes on assignment status
6962: IF l_chg_table = 'PER_ALL_ASSIGNMENTS_F' THEN
6963:
6964: IF l_chg_column_name = 'ASSIGNMENT_STATUS_TYPE_ID' THEN
6965:
6966: l_assignment_status_type_id := g_pay_proc_evt_tab(l_index).new_value;

Line 6994: END IF; --IF (l_chg_table = 'PER_ALL_ASSIGNMENTS_F'

6990: debug_exit(l_proc);
6991: RETURN 'Y';
6992: END IF;
6993:
6994: END IF; --IF (l_chg_table = 'PER_ALL_ASSIGNMENTS_F'
6995:
6996:
6997: -- looping condition
6998: IF l_index = g_pay_proc_evt_tab.LAST THEN

Line 7081: IF (l_chg_table = 'PER_ALL_ASSIGNMENTS_F'

7077: g_salary_ele_end_date := g_effective_date;
7078: l_sal_ele_end := 'Y';
7079: END IF;
7080:
7081: IF (l_chg_table = 'PER_ALL_ASSIGNMENTS_F'
7082: AND (l_chg_column_name IN ('GRADE_ID','NORMAL_HOURS') OR l_chg_type = 'I'))
7083: OR (l_chg_table = 'PQP_ASSIGNMENT_ATTRIBUTES_F'
7084: AND (l_chg_column_name = 'CONTRACT_TYPE' OR l_chg_type = 'I'))
7085: OR (l_chg_table = 'PAY_ELEMENT_ENTRIES_F'

Line 7091: END IF; --IF (l_chg_table = 'PER_ALL_ASSIGNMENTS_F'

7087: OR (l_chg_table = 'PAY_ELEMENT_ENTRY_VALUES_F') THEN
7088:
7089: g_sal_chg_event_exists := 'Y';
7090:
7091: END IF; --IF (l_chg_table = 'PER_ALL_ASSIGNMENTS_F'
7092:
7093: IF (l_chg_table = 'PER_ASSIGNMENT_BUDGET_VALUES_F'
7094: AND (l_chg_column_name = 'VALUE' OR l_chg_type = 'I' )) THEN
7095:

Line 7233: IF l_chg_table = 'PER_ALL_ASSIGNMENTS_F'

7229:
7230: debug('l_chg_table: '||l_chg_table||' l_chg_date: '||l_chg_date||
7231: ' l_update_type: '||l_update_type||' l_chg_column_name: '||l_chg_column_name);
7232:
7233: IF l_chg_table = 'PER_ALL_ASSIGNMENTS_F'
7234: AND (l_chg_column_name = 'ASSIGNMENT_STATUS_TYPE_ID'
7235: OR l_update_type = 'E') THEN
7236:
7237: IF PQP_GB_PSI_FUNCTIONS.chk_is_employee_a_leaver

Line 7274: ELSIF (l_chg_table = 'PER_ALL_ASSIGNMENTS_F'

7270: AND l_update_type = 'E' THEN
7271: -- if there is a element entry end.
7272: l_sal_ele_end_evt_exist := 'Y';
7273:
7274: ELSIF (l_chg_table = 'PER_ALL_ASSIGNMENTS_F'
7275: AND (l_chg_column_name IN ('GRADE_ID','NORMAL_HOURS') OR l_update_type = 'I'))
7276: OR (l_chg_table = 'PQP_ASSIGNMENT_ATTRIBUTES_F'
7277: AND (l_chg_column_name = 'CONTRACT_TYPE' OR l_update_type = 'I'))
7278: OR (l_chg_table = 'PAY_ELEMENT_ENTRY_VALUES_F') THEN

Line 7327: IF l_chg_table = 'PER_ALL_ASSIGNMENTS_F'

7323: l_chg_table_id := g_pay_proc_evt_tab(l_index).dated_table_id;
7324: l_update_type := g_pay_proc_evt_tab(l_index).update_type;
7325: l_chg_column_name := g_pay_proc_evt_tab(l_index).column_name;
7326:
7327: IF l_chg_table = 'PER_ALL_ASSIGNMENTS_F'
7328: AND (l_chg_column_name = 'ASSIGNMENT_STATUS_TYPE_ID'
7329: OR l_update_type = 'E') THEN
7330:
7331: IF PQP_GB_PSI_FUNCTIONS.chk_is_employee_a_leaver

Line 7364: END IF; -- IF l_chg_table = 'PER_ALL_ASSIGNMENTS_F'

7360: RETURN 'Y';
7361:
7362: END IF; --IF l_assignment_status <> 'PROCESS'
7363:
7364: END IF; -- IF l_chg_table = 'PER_ALL_ASSIGNMENTS_F'
7365:
7366: END IF; -- IF l_chg_date = (l_next_event_date + 1)
7367:
7368: END IF; --IF l_sal_ele_end_evt_exist = 'Y'

Line 7437: OR (l_chg_table = 'PER_ALL_ASSIGNMENTS_F'

7433: --For bug 7013325: Added new column l_configured_dff_segment
7434: IF (l_chg_table = 'PAY_ELEMENT_ENTRIES_F'
7435: AND l_chg_type <> 'E')
7436: OR (l_chg_table = 'PAY_ELEMENT_ENTRY_VALUES_F')
7437: OR (l_chg_table = 'PER_ALL_ASSIGNMENTS_F'
7438: AND (l_chg_column_name IN ('GRADE_ID','NORMAL_HOURS','EMPLOYMENT_CATEGORY',l_configured_dff_segment) OR l_chg_type = 'I'))
7439: OR (l_chg_table = 'PQP_ASSIGNMENT_ATTRIBUTES_F'
7440: AND (l_chg_column_name = 'CONTRACT_TYPE' OR l_chg_type = 'I'))THEN
7441:

Line 7446: END IF; --IF (l_chg_table = 'PER_ALL_ASSIGNMENTS_F'

7442: debug('Returning Y');
7443: debug_exit(l_proc);
7444: RETURN 'Y';
7445:
7446: END IF; --IF (l_chg_table = 'PER_ALL_ASSIGNMENTS_F'
7447:
7448: IF (l_chg_table = 'PER_ASSIGNMENT_BUDGET_VALUES_F'
7449: AND (l_chg_column_name = 'VALUE' OR l_chg_type = 'I' )) THEN
7450: