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.CN_ROLE_PAY_GROUPS_PVT dependencies on CN_SRP_PAY_GROUPS_S

Line 46: l_start_date cn_srp_pay_groups.start_date%TYPE;

42: p_srp_role_id IN NUMBER,
43: x_start_date OUT NOCOPY DATE,
44: x_end_date OUT NOCOPY DATE) IS
45:
46: l_start_date cn_srp_pay_groups.start_date%TYPE;
47: l_end_date cn_srp_pay_groups.start_date%TYPE;
48:
49:
50: l_res_start_date cn_srp_pay_groups.start_date%TYPE;

Line 47: l_end_date cn_srp_pay_groups.start_date%TYPE;

43: x_start_date OUT NOCOPY DATE,
44: x_end_date OUT NOCOPY DATE) IS
45:
46: l_start_date cn_srp_pay_groups.start_date%TYPE;
47: l_end_date cn_srp_pay_groups.start_date%TYPE;
48:
49:
50: l_res_start_date cn_srp_pay_groups.start_date%TYPE;
51: l_res_end_date cn_srp_pay_groups.start_date%TYPE;

Line 50: l_res_start_date cn_srp_pay_groups.start_date%TYPE;

46: l_start_date cn_srp_pay_groups.start_date%TYPE;
47: l_end_date cn_srp_pay_groups.start_date%TYPE;
48:
49:
50: l_res_start_date cn_srp_pay_groups.start_date%TYPE;
51: l_res_end_date cn_srp_pay_groups.start_date%TYPE;
52:
53: l_role_pg_start_date cn_srp_pay_groups.start_date%TYPE;
54: l_role_pg_end_date cn_srp_pay_groups.start_date%TYPE;

Line 51: l_res_end_date cn_srp_pay_groups.start_date%TYPE;

47: l_end_date cn_srp_pay_groups.start_date%TYPE;
48:
49:
50: l_res_start_date cn_srp_pay_groups.start_date%TYPE;
51: l_res_end_date cn_srp_pay_groups.start_date%TYPE;
52:
53: l_role_pg_start_date cn_srp_pay_groups.start_date%TYPE;
54: l_role_pg_end_date cn_srp_pay_groups.start_date%TYPE;
55:

Line 53: l_role_pg_start_date cn_srp_pay_groups.start_date%TYPE;

49:
50: l_res_start_date cn_srp_pay_groups.start_date%TYPE;
51: l_res_end_date cn_srp_pay_groups.start_date%TYPE;
52:
53: l_role_pg_start_date cn_srp_pay_groups.start_date%TYPE;
54: l_role_pg_end_date cn_srp_pay_groups.start_date%TYPE;
55:
56: l_srp_role_start_date cn_srp_pay_groups.start_date%TYPE;
57: l_srp_role_end_date cn_srp_pay_groups.start_date%TYPE;

Line 54: l_role_pg_end_date cn_srp_pay_groups.start_date%TYPE;

50: l_res_start_date cn_srp_pay_groups.start_date%TYPE;
51: l_res_end_date cn_srp_pay_groups.start_date%TYPE;
52:
53: l_role_pg_start_date cn_srp_pay_groups.start_date%TYPE;
54: l_role_pg_end_date cn_srp_pay_groups.start_date%TYPE;
55:
56: l_srp_role_start_date cn_srp_pay_groups.start_date%TYPE;
57: l_srp_role_end_date cn_srp_pay_groups.start_date%TYPE;
58:

Line 56: l_srp_role_start_date cn_srp_pay_groups.start_date%TYPE;

52:
53: l_role_pg_start_date cn_srp_pay_groups.start_date%TYPE;
54: l_role_pg_end_date cn_srp_pay_groups.start_date%TYPE;
55:
56: l_srp_role_start_date cn_srp_pay_groups.start_date%TYPE;
57: l_srp_role_end_date cn_srp_pay_groups.start_date%TYPE;
58:
59: l_pg_start_date cn_srp_pay_groups.start_date%TYPE;
60: l_pg_end_date cn_srp_pay_groups.start_date%TYPE;

Line 57: l_srp_role_end_date cn_srp_pay_groups.start_date%TYPE;

53: l_role_pg_start_date cn_srp_pay_groups.start_date%TYPE;
54: l_role_pg_end_date cn_srp_pay_groups.start_date%TYPE;
55:
56: l_srp_role_start_date cn_srp_pay_groups.start_date%TYPE;
57: l_srp_role_end_date cn_srp_pay_groups.start_date%TYPE;
58:
59: l_pg_start_date cn_srp_pay_groups.start_date%TYPE;
60: l_pg_end_date cn_srp_pay_groups.start_date%TYPE;
61:

Line 59: l_pg_start_date cn_srp_pay_groups.start_date%TYPE;

55:
56: l_srp_role_start_date cn_srp_pay_groups.start_date%TYPE;
57: l_srp_role_end_date cn_srp_pay_groups.start_date%TYPE;
58:
59: l_pg_start_date cn_srp_pay_groups.start_date%TYPE;
60: l_pg_end_date cn_srp_pay_groups.start_date%TYPE;
61:
62: l_org_id NUMBER;
63: l_salesrep_id NUMBER;

Line 60: l_pg_end_date cn_srp_pay_groups.start_date%TYPE;

56: l_srp_role_start_date cn_srp_pay_groups.start_date%TYPE;
57: l_srp_role_end_date cn_srp_pay_groups.start_date%TYPE;
58:
59: l_pg_start_date cn_srp_pay_groups.start_date%TYPE;
60: l_pg_end_date cn_srp_pay_groups.start_date%TYPE;
61:
62: l_org_id NUMBER;
63: l_salesrep_id NUMBER;
64: l_pay_group_id NUMBER;

Line 813: l_srp_pay_group_id cn_srp_pay_groups.srp_pay_group_id%TYPE;

809:
810: l_role_pg_rec role_pay_groups_rec_type;
811: l_rec l_srp_cur%ROWTYPE;
812: l_lock_flag VARCHAR2(1);
813: l_srp_pay_group_id cn_srp_pay_groups.srp_pay_group_id%TYPE;
814: l_object_version_number cn_srp_pay_groups.object_version_number%TYPE;
815: l_start_date DATE;
816: l_end_date DATE;
817:

Line 961: SELECT cn_srp_pay_groups_s.NEXTVAL

957:
958: IF l_count = 0 THEN
959: l_lock_flag := 'N';
960:
961: SELECT cn_srp_pay_groups_s.NEXTVAL
962: INTO l_srp_pay_group_id
963: FROM dual;
964:
965: CN_SRP_Pay_Groups_Pkg.Begin_Record