APPS.JTF_CAL_UTILITY_PVT dependencies on JTF_PERZ_DATA

Line 544: FROM jtf_perz_data

540: IS
541: CURSOR c_category
542: (b_category_id NUMBER)
543: IS SELECT perz_data_desc name
544: FROM jtf_perz_data
545: WHERE perz_data_id = b_category_id;
546:
547: r_Category c_Category%ROWTYPE;
548:

Line 684: , jtf_perz_data jpd

680: ,b_ResourceType VARCHAR2 -- Resource Type of Calendar User
681: ,b_GroupID NUMBER -- Group ID of Group Calendar
682: )IS SELECT jpa.attribute_value color
683: FROM jtf_perz_profile jpp
684: , jtf_perz_data jpd
685: , jtf_perz_data_attrib jpa
686: WHERE jpp.profile_name = to_char(b_ResourceID)||':JTF_CAL'
687: AND jpp.profile_id = jpd.profile_id
688: AND jpa.perz_data_id = jpd.perz_data_id

Line 685: , jtf_perz_data_attrib jpa

681: ,b_GroupID NUMBER -- Group ID of Group Calendar
682: )IS SELECT jpa.attribute_value color
683: FROM jtf_perz_profile jpp
684: , jtf_perz_data jpd
685: , jtf_perz_data_attrib jpa
686: WHERE jpp.profile_name = to_char(b_ResourceID)||':JTF_CAL'
687: AND jpp.profile_id = jpd.profile_id
688: AND jpa.perz_data_id = jpd.perz_data_id
689: AND jpa.attribute_name = to_char(b_GroupID)||':COLOR';

Line 740: , jtf_perz_data jpd

736: ,b_ResourceType VARCHAR2 -- Resource Type of Calendar User
737: ,b_GroupID NUMBER -- Group ID of Group Calendar
738: )IS SELECT flu.meaning color
739: FROM jtf_perz_profile jpp
740: , jtf_perz_data jpd
741: , jtf_perz_data_attrib jpa
742: , fnd_lookups flu
743: WHERE jpp.profile_name = to_char(b_ResourceID)||':JTF_CAL'
744: AND jpp.profile_id = jpd.profile_id

Line 741: , jtf_perz_data_attrib jpa

737: ,b_GroupID NUMBER -- Group ID of Group Calendar
738: )IS SELECT flu.meaning color
739: FROM jtf_perz_profile jpp
740: , jtf_perz_data jpd
741: , jtf_perz_data_attrib jpa
742: , fnd_lookups flu
743: WHERE jpp.profile_name = to_char(b_ResourceID)||':JTF_CAL'
744: AND jpp.profile_id = jpd.profile_id
745: AND jpa.perz_data_id = jpd.perz_data_id

Line 800: , jtf_perz_data jpd

796: ,b_ResourceType VARCHAR2 -- Resource Type of Calendar User
797: ,b_GroupID NUMBER -- Group ID of Group Calendar
798: )IS SELECT jpa.attribute_value color
799: FROM jtf_perz_profile jpp
800: , jtf_perz_data jpd
801: , jtf_perz_data_attrib jpa
802: WHERE jpp.profile_name = to_char(b_ResourceID)||':JTF_CAL'
803: AND jpp.profile_id = jpd.profile_id
804: AND jpa.perz_data_id = jpd.perz_data_id

Line 801: , jtf_perz_data_attrib jpa

797: ,b_GroupID NUMBER -- Group ID of Group Calendar
798: )IS SELECT jpa.attribute_value color
799: FROM jtf_perz_profile jpp
800: , jtf_perz_data jpd
801: , jtf_perz_data_attrib jpa
802: WHERE jpp.profile_name = to_char(b_ResourceID)||':JTF_CAL'
803: AND jpp.profile_id = jpd.profile_id
804: AND jpa.perz_data_id = jpd.perz_data_id
805: AND jpa.attribute_name = to_char(b_GroupID)||':PREFIX';

Line 907: , jtf_perz_data jpd

903: (b_ResourceID IN NUMBER
904: )IS SELECT jpa.attribute_name AttributeName
905: , jpa.attribute_value AttributeValue
906: FROM jtf_perz_profile jpp
907: , jtf_perz_data jpd
908: , jtf_perz_data_attrib jpa
909: WHERE jpp.profile_name = to_char(b_ResourceID)||':JTF_CAL'
910: AND jpp.profile_id = jpd.profile_id
911: AND jpd.perz_data_id = jpa.perz_data_id

Line 908: , jtf_perz_data_attrib jpa

904: )IS SELECT jpa.attribute_name AttributeName
905: , jpa.attribute_value AttributeValue
906: FROM jtf_perz_profile jpp
907: , jtf_perz_data jpd
908: , jtf_perz_data_attrib jpa
909: WHERE jpp.profile_name = to_char(b_ResourceID)||':JTF_CAL'
910: AND jpp.profile_id = jpd.profile_id
911: AND jpd.perz_data_id = jpa.perz_data_id
912: AND jpa.attribute_name IN ( 'APPT_INCR'