APPS.PAY_IE_PAYE_PKG dependencies on FND_SESSIONS

Line 354: -- ,FND_SESSIONS SESH

350: PAY_ELEMENT_ENTRY_VALUES_F VALUE,
351: PAY_ELEMENT_ENTRIES_F ENTRY,
352: PER_TIME_PERIODS PTP,
353: PAY_PAYROLL_ACTIONS PACT
354: -- ,FND_SESSIONS SESH
355: WHERE
356: PACT.PAYROLL_ACTION_ID = P_PAYROLL_ACTION_ID AND
357: --PTP.TIME_PERIOD_ID = PACT.TIME_PERIOD_ID AND -- Bug 5070091 Offset payroll change
358: PACT.PAYROLL_ID = PTP.PAYROLL_ID AND

Line 902: FROM ff_globals_f,fnd_sessions ses

898: RETURN number
899: is
900: CURSOR get_global_val(l_name IN VARCHAR2) IS
901: SELECT global_value
902: FROM ff_globals_f,fnd_sessions ses
903: WHERE global_name = l_name
904: AND ses.session_id = userenv('SESSIONID')
905: AND ses.effective_date BETWEEN effective_start_date AND effective_end_date;
906: --

Line 909: FROM pay_all_payrolls_f pp, per_all_assignments_f pa,fnd_sessions ses

905: AND ses.effective_date BETWEEN effective_start_date AND effective_end_date;
906: --
907: CURSOR get_pay_frequency_csr IS
908: SELECT pp.period_type
909: FROM pay_all_payrolls_f pp, per_all_assignments_f pa,fnd_sessions ses
910: WHERE pa.assignment_id = p_assignment_id
911: AND ses.session_id = userenv('SESSIONID')
912: AND ses.effective_date BETWEEN pa.effective_start_date AND pa.effective_end_date
913: AND pp.payroll_id = pa.payroll_id

Line 918: FROM pay_ie_paye_details_f pp,fnd_sessions ses

914: AND ses.effective_date BETWEEN pp.effective_start_date AND pp.effective_end_date;
915: --
916: CURSOR monthly_std_rate_cut_off IS
917: SELECT nvl(pp.monthly_std_rate_cut_off,0)
918: FROM pay_ie_paye_details_f pp,fnd_sessions ses
919: WHERE pp.assignment_id=p_assignment_id
920: AND ses.session_id = userenv('SESSIONID')
921: AND ses.effective_date BETWEEN pp.effective_start_date AND pp.effective_end_date;
922: --

Line 964: FROM ff_globals_f,fnd_sessions ses

960: RETURN number
961: is
962: CURSOR get_global_val(l_name IN VARCHAR2) IS
963: SELECT global_value
964: FROM ff_globals_f,fnd_sessions ses
965: WHERE global_name = l_name
966: AND ses.session_id = userenv('SESSIONID')
967: AND ses.effective_date BETWEEN effective_start_date AND effective_end_date;
968: --

Line 971: FROM pay_all_payrolls_f pp, per_all_assignments_f pa,fnd_sessions ses

967: AND ses.effective_date BETWEEN effective_start_date AND effective_end_date;
968: --
969: CURSOR get_pay_frequency_csr IS
970: SELECT pp.period_type
971: FROM pay_all_payrolls_f pp, per_all_assignments_f pa,fnd_sessions ses
972: WHERE pa.assignment_id = p_assignment_id
973: AND ses.session_id = userenv('SESSIONID')
974: AND ses.effective_date BETWEEN pa.effective_start_date AND pa.effective_end_date
975: AND pp.payroll_id = pa.payroll_id

Line 980: FROM pay_ie_paye_details_f pp,fnd_sessions ses

976: AND ses.effective_date BETWEEN pp.effective_start_date AND pp.effective_end_date;
977: --
978: CURSOR monthly_tax_credit IS
979: SELECT nvl(pp.monthly_tax_credit,0)
980: FROM pay_ie_paye_details_f pp,fnd_sessions ses
981: WHERE pp.assignment_id=p_assignment_id
982: AND ses.session_id = userenv('SESSIONID')
983: AND ses.effective_date BETWEEN pp.effective_start_date AND pp.effective_end_date;
984: --

Line 1031: FROM ff_globals_f,fnd_sessions ses

1027: RETURN number
1028: is
1029: CURSOR get_global_val(l_name IN VARCHAR2) IS
1030: SELECT global_value
1031: FROM ff_globals_f,fnd_sessions ses
1032: WHERE global_name = l_name
1033: AND ses.session_id = userenv('SESSIONID')
1034: AND ses.effective_date BETWEEN effective_start_date AND effective_end_date;
1035: --

Line 1038: FROM pay_all_payrolls_f pp, per_all_assignments_f pa,fnd_sessions ses

1034: AND ses.effective_date BETWEEN effective_start_date AND effective_end_date;
1035: --
1036: CURSOR get_pay_frequency_csr IS
1037: SELECT pp.period_type
1038: FROM pay_all_payrolls_f pp, per_all_assignments_f pa,fnd_sessions ses
1039: WHERE pa.assignment_id = p_assignment_id
1040: AND ses.session_id = userenv('SESSIONID')
1041: AND ses.effective_date BETWEEN pa.effective_start_date AND pa.effective_end_date
1042: AND pp.payroll_id = pa.payroll_id

Line 1047: FROM pay_ie_paye_details_f pp,fnd_sessions ses

1043: AND ses.effective_date BETWEEN pp.effective_start_date AND pp.effective_end_date;
1044: --
1045: CURSOR weekly_std_rate_cut_off IS
1046: SELECT nvl(pp.weekly_std_rate_cut_off,0)
1047: FROM pay_ie_paye_details_f pp,fnd_sessions ses
1048: WHERE pp.assignment_id=p_assignment_id
1049: AND ses.session_id = userenv('SESSIONID')
1050: AND ses.effective_date BETWEEN pp.effective_start_date AND pp.effective_end_date;
1051: --

Line 1094: FROM ff_globals_f,fnd_sessions ses

1090: RETURN number
1091: is
1092: CURSOR get_global_val(l_name IN VARCHAR2) IS
1093: SELECT global_value
1094: FROM ff_globals_f,fnd_sessions ses
1095: WHERE global_name = l_name
1096: AND ses.session_id = userenv('SESSIONID')
1097: AND ses.effective_date BETWEEN effective_start_date AND effective_end_date;
1098: --

Line 1101: FROM pay_all_payrolls_f pp, per_all_assignments_f pa,fnd_sessions ses

1097: AND ses.effective_date BETWEEN effective_start_date AND effective_end_date;
1098: --
1099: CURSOR get_pay_frequency_csr IS
1100: SELECT pp.period_type
1101: FROM pay_all_payrolls_f pp, per_all_assignments_f pa,fnd_sessions ses
1102: WHERE pa.assignment_id = p_assignment_id
1103: AND ses.session_id = userenv('SESSIONID')
1104: AND ses.effective_date BETWEEN pa.effective_start_date AND pa.effective_end_date
1105: AND pp.payroll_id = pa.payroll_id

Line 1110: FROM pay_ie_paye_details_f pp,fnd_sessions ses

1106: AND ses.effective_date BETWEEN pp.effective_start_date AND pp.effective_end_date;
1107: --
1108: CURSOR weekly_tax_credit IS
1109: SELECT nvl(pp.weekly_tax_credit,0)
1110: FROM pay_ie_paye_details_f pp,fnd_sessions ses
1111: WHERE pp.assignment_id=p_assignment_id
1112: AND ses.session_id = userenv('SESSIONID')
1113: AND ses.effective_date BETWEEN pp.effective_start_date AND pp.effective_end_date;
1114: --